Back to vBulletin 3 Articles

How Many Queries on a New Installation
by TheInsaneManiac 24 Sep 2008

So, you want to compare your current website's queries to a new installation ehh? Well then I can help you with that. First you will need some type of script that will tell you the amount of queries on a specific page. Lynne told me about one and it seems to work fine. It's called Microstats. You can get Microstats HERE:
Microstats - load times, server loads, queries, uncached templates

Even though it says it is for 3.5, it works on 3.7 as this is what I installed for a new installation.

Note: These are ONLY the queries for a new installation of VBulletin 3.7.3 and will probably differ from 3.6.

index.php - 8 Queries
member.php?u=1 - 18 Queries
faq.php - 8 Queries
calendar.php - 10 Queries
search.php - 10 Queries
search.php?do=getnew - 10 Queries
online.php - 9 Queries
usercp.php - 15 Queries
profile.php - 9 Queries
profile.php?do=editprofile - 9 Queries
profile.php?do=editprofilepic - 9 Queries
profile.php?do=buddylist - 10 Queries
profile.php?do=editavatar - 11 Queries
profile.php?do=editsignature - 10 Queries
profile.php?do=editpassword - 8 Queries
profile.php?do=editoptions - 10 Queries
profile.php?do=ignorelist - 9 Queries
profile.php?do=editattachments - 9 Queries
private.php - 10 Queries
private.php?do=newpm - 12 Queries
private.php?do=trackpm - 13 Queries
private.php?do=editfolders - 9 Queries
group.php - 8
album.php?u=1 - 9 Queries
subscription.php?do=viewsubscription - 10 Queries
subscription.php?do=editfolders - 8 Queries
calendar.php?do=viewreminder - 12 Queries
payments.php - 12 Queries
moderation.php?do=viewthreads&type=deleted - 9 Queries
moderation.php?do=viewposts&type=deleted - 9 Queries
moderation.php?do=viewvms&type=deleted - 11 Queries
moderation.php?do=viewgms&type=deleted - 11 Queries
moderation.php?do=viewpcs&type=deleted - 11 Queries
moderation.php?do=viewthreads&type=moderated - 9 Queries
moderation.php?do=viewposts&type=moderated - 9 Queries
moderation.php?do=viewvms&type=moderated - 11 Queries
moderation.php?do=viewgms&type=moderated - 11 Queries
moderation.php?do=viewpcs&type=moderated - 11 Queries
moderation.php?do=viewpics - 11 Queries

vblts.ru supports vBulletin®, 2022-2024