In Progress

Script Mysql Optimization For Vbulletin Plugin

Hello,

I have a simple seo plugin that shows google search queries under showthread pages. However this script is poorly optimized and consumes lots of server resources. And it shows slow mysql queries all the time. As an example from slow queries log is in the end of the project.

I want this plugin to be mysql optimized and probably use a cache if its possible. Plugin file is in the attachement.

st.*, [url removed, login to view]

FROM

vb_seoqueries_data sd

LEFT JOIN

vb_seoqueries_terms st

ON

[url removed, login to view] = [url removed, login to view]

WHERE

[url removed, login to view] = 0

AND

sd.page_type = 'showthread'

AND

sd.page_id = 135478

ORDER BY

[url removed, login to view] DESC LIMIT 5;

Skills: MySQL, PHP, vBulletin

See more: mysql search optimization, php end script, vbulletin php mysql, search google mysql, google php search script, mysql server example, script php vbulletin, slow queries, php server optimization, vbulletin google, mysql plugin, vbulletin slow mysql, showthread vbulletin, mysql slow queries, mysql log, plugin seo, mysql slow, ban script mysql, cache mysql, mysql join, php script search shows, vbulletin mysql queries, mysql plugin php, vbulletin slow queries, simple seo script

About the Employer:
( 4 reviews ) Istanbul, Turkey

Project ID: #2548418

Awarded to:

triamazikamno

Professional server/website optimiser.

$150 USD in 2 days
(48 Reviews)
6.2

5 freelancers are bidding on average $154 for this job

gopalvora

ready to start Thanks

$120 USD in 4 days
(228 Reviews)
7.1
RBenard

Please check PM, it will be done the same day.

$150 USD in 3 days
(130 Reviews)
6.6
sobhnath

Pls. check PMB and also Pls. check my review for mysql.

$150 USD in 4 days
(8 Reviews)
4.1
krkcare

Hi, We have gone through your requirement and have sent you a private message. Kindly check that. Thanks

$200 USD in 2 days
(3 Reviews)
3.6