PDA

View Full Version : Concequences of Too Many Queries

GaleForce
05-04-2003, 07:48 PM
Just curious, aside from slower load times and increased bandwith, what are some of the other consequences of running too many queries?
Xenon
05-04-2003, 07:53 PM
problems with your host ^^

even sometimes errors can occur..
GaleForce
05-04-2003, 08:05 PM
My host doesn't seem to mind just as long as I don't exceed my bandwith, and I don't really get errors unless I mess up a hack. I run tons of queries and my speed is hardly effected so I guess I am in good standing :p
NTLDR
05-04-2003, 09:24 PM
An increase in queries will only result in increased bandwidth iff they are used in producing extra stuff that will be sent to the browser :)
filburt1
05-04-2003, 09:35 PM
It can even crash the server and corrupt your database. Also it's just not good coding.
GaleForce
05-04-2003, 09:55 PM
Well, I will hold off on installing more hacks than. My forums have been up for almost a year and I haven't had any crashes due to my massive, excessive amount of queries, so I think I am alright in that department. As for the bandwith, I get 30gb and I never come near that number, so I am fine in that department as well.

Thanks for all the information, I will keep it in mind :)
filburt1
05-04-2003, 10:08 PM
Your host will get ++++ed off, though...
Boofo
05-04-2003, 10:59 PM
GaleForce, I wouls say this is far past too many queries. ;)

Page generated in 0.55015099 seconds (62.84% PHP - 37.16% MySQL) with 297 queries.
GaleForce
05-04-2003, 11:01 PM
Don't worry, some pages do 305 :)
GaleForce
05-04-2003, 11:01 PM
Today at 12:08 AM filburt1 said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=391479#post391479)
Your host will get ++++ed off, though...

Like I said, he told me it was alright as long as I didn't consume excessive bandwith or crash the servers :)
Boofo
05-04-2003, 11:05 PM
Check your php files and remember to put any templates you use in the templateused line. That might help reduce the query load a bit. Every little bit helps.
GaleForce
05-05-2003, 12:35 AM
What do you mean by the templateused line?
Boofo
05-05-2003, 12:42 AM
Look at the top of any section you add a hack to. There is a line there like this:

templatesused=forumhome_forumbit_level1_nopost,

For example, the above is in index.php for the forumhome (with more template names after the first one, though).
GaleForce
05-05-2003, 01:34 AM
Alright, thanks, I will look into that :)