How many queries on average does everyone have on their homepage in vbulletin? I make that sound like a competition for the highest lol but I would like to know what is too many and how many others have running.
Not Logged-In: Homepage: 6 queries Forumhome: 9 queries Logged-in as Admin: Homepage: 8 queries Forumhome: 13 queries
Damn I thought I was doing well when I got it down to 16 logged in lol I think it is at 10 not logged in
How can you get them that low? Our teen forum has 29 queries on the home loggedin, im not sure how to see how many logged out.
I think people put too much emphasis on "number of queries". It really is a meaningless number. If you are using a properly configured and optimized MySQL server, it should be capable of running over 20,000 queries per second. Unless you have a few thousand people online at a time, you're not going to hit that. With newer quad-core and octo-core servers, you can probably get 40,000-60,000 queries per second. While this is below what you can get out of Oracle or MS SQL Server (both are over 100,000 queries per second), it isn't something to laugh at. You can write one bad query that takes over a second to process. Or you can write 10 optimized queries that process in mere milliseconds. If your page is processed in less than 300-400 milliseconds, most people aren't going to notice. More time will be spent handshaking connections to download images. BTW, the default forumhome for vBulletin has 8-14 queries depending on the features enabled. I have seen it lowered to as few as 4 with heavy caching.
I've tuned off some features for guests like the list of logged-in members on forumhome. They don't need to see that. So true.
Basically speaking, a query is a question to the database, e.g. What user has the userid of 16? Or a request for data e.g.: Show me all users that registered between 06:00 and 13:00 hours on May 15th, 2009. Or you can use it to tell the database to store information for you, e.g. Add a new user with the username of bob and the password of p4ssw0rd. The actual language used is a little more technical but the same basic principle applies. It is how an application gets information from the database. Every page you view and form you submit runs multiple queries.
I use the KX or ZH debug mod from vb.org as well as KX or ZH template cache for quickly caching uncached templates
