VBSEO Causing Slow Queries

Since upgrading to VBSEO 3.20 Gold, my forums have slowed down drastically, due to numerous slow queries. I paid 3 different programmers to find the issues, the last one said it was VBSEO.

Am I the only one?

How can I get rid of these slow queries?

I have examples, but am not sure if I can post code

Thanks for your valuable time and support.

Do you use vb 3.7.x + tag system?

Those KILLED my site when i had a lot of them.

I reported it to vb, but like usual no one (on the staff) seemed to care.
Tags Tag search queries need to be revisited - vBulletin Community Forum


Otherwise, how big (active) is your site, and what kind of server are you on? It may simply be time to upgrade to better hosting now that yo'ure getting more traffic.

yes, we are using vb 3.73 pl2 and are utilizing the tags feature.

vbulletin will not even attempt to discuss issues created by third party add-ons.

we have anywhere from 750-1500 users online at any given time.
already setup with dedicated hosting, one web server, one database server, both with 4 gigs and 2 processors. our hardware is more than enough to handle the load, just need to get rid of these slow queries. some people have deep pockets and can throw more hardware at the problem, but the problem is still there and my pockets are not that deep.

is this an issue handled under tech support of vbseo?

thanks for your support!

The first step is to figure out what processes are locking/holding up the site.

When your site is getting slow, run this a few times from ssh

Code:

 mysql -e 'show full processlist'

if you have locked or waiting queries under it for more than the time it takes you to refresh, that query is hanging.

generally, you should only have 2 or 3 records at any one time, one of whihc is you running this, and possibly one or two others that happened to be running at the split second that you ran the command.


Further, it may not be sql at all. If everything looks good there when your site is crawling, it might be another process on your box (a cron task, or apache/web server overload)

Once you figure out what exactly is causing the hang, we can help you further.

if you have examples, by all mean, post them with a benchmark of some sort