Queries?

[raiderlax]

How do you see how many are being generated on any single page?

thanks

[Andy Huang]

Debug mode will do that for you, but it does cause a little bit of overhead. It is slightly different for the different streams of vbulletin. For 3.6.x series, please add this in a new line immediately after <?php in your config.php

$config['Misc']['debug'] = '1';

Once you've found out the details, it is recommended that you disable debug mode by removing the above line so it saves the overhead and does not disclose potentially senstive information.

[raiderlax]

Thanks Andy, I found I have 15 queries running on FORUMHOME, is this bad?

[Floris]

That's fine. vBulletin runs between 7 and 13 queries on the forumhome, and a few more if you have plugins installed that add more. 15 is just fine in my eyes. I always try to stay below 15, and certainly below 20.

[Jose Amaral Rego]

What if you use multiple Really Simple Syndication (RSS) on one forum, does it add for each one you add to forum... Just testing this out now to see if this can shut me out of my server that I am on. I should post in support, but I am going to see how many I can run to bring down my site. Just for testing.

Did not add any more queries to page... I am running 24 feed at one time in one forum

[MRGTB]

What if you use multiple Really Simple Syndication (RSS) on one forum, does it add for each one you add to forum... Just testing this out now to see if this can shut me out of my server that I am on. I should post in support, but I am going to see how many I can run to bring down my site. Just for testing.

Did not add any more queries to page... I am running 24 feed at one time in one forum

Let me know the results, as I'm also running quite a few feeds coming in. And am interested to know if each feeds you add - adds an extra query.

[Jose Amaral Rego]

Let me know the results, as I'm also running quite a few feeds coming in. And am interested to know if each feeds you add - adds an extra query.

Did not add any more queries to page... I am running 24 feed at one time in one forum

I did, but do not know how many once it has posted, I have 50+ now and it still shows the same queries plus 1 if I did not have it running.

Need to ask Devs and or Staff it see if any more queries are added once you run schedule task. I can only see after posting is created and do not know how much server load it contributes for eack feed.

[Andy Huang]

Feeds coming in does not increase query count on the pages. It does add work load to the cron job image though.

[raiderlax]

That's fine. vBulletin runs between 7 and 13 queries on the forumhome, and a few more if you have plugins installed that add more. 15 is just fine in my eyes. I always try to stay below 15, and certainly below 20.

Okay thanks alot, well I guess since I have vBSEO installed that is what is adding those extra queries as well as a sidebar hack I have installed.

What do queries do, like if you had more do they slow down the site?, does it have anything to do with the sites speed?

[Floris]

Very big web sites do notice a decrease in performance using additional addons, such as vBSEO, because their .htaccess and mod_rewrite is being used, and vBulletin runs additional queries and PHP before it presents it to the end user. But this goes for any addon which requires resources.