Ack! Tons of queries [Archive]

View Full Version : Ack! Tons of queries

Night Owl

11-01-2002, 03:15 AM

I just went to my vbportal home page and it's showing 63 queries! What can be causing this?

http://www.sybermoms.com

Also, the pages inside my board show between 20 and 30 queries. What can I do to determine what is causing these queries and what I can change?

Thank you!

Smoothie

11-01-2002, 04:04 AM

debug mode will tell you where your queries are coming from.

JulianD

11-01-2002, 02:11 PM

It's normal when you install PHP Portals...

NTLDR

11-01-2002, 04:58 PM

Standard vBPortal home page has 53 Queries on it. There dev site had 108 on there home page!

filburt1

11-01-2002, 07:29 PM

53 is still pretty insane, there aren't even that many vB tables. At that point they could practically just run "SELECT * FROM tablename" for each table and let PHP do all the work :rolleyes:

N9ne

11-01-2002, 07:30 PM

I really wouldn't install something if it runs over 50 queries everytime the page is viewed :o

Erwin

11-02-2002, 12:31 AM

It's standard for vBPortal - when I ran it I had over 200!!!

This is because when you run their "Latest Discussion" table, each thread is 1 query - very inefficient. Also, templates are not included, so every template called is another query.

It's just badly optimized code.

I suggest changing over to vBHome Lite or vBIndex as free alternatives to vBPortal. Otherwise, when you site gets busy, it's going to bring the server down.

NTLDR

11-02-2002, 06:18 PM

Originally posted by Erwin
It's standard for vBPortal - when I ran it I had over 200!!!

Whoa! Thats alot of queries for no benifit IMO. I will be writing my own version of vBP for my Degree, I'm pretty sure I can use less queries than this ;)