PDA

View Full Version : Optimize Query Load...

Kevorkian
03-23-2003, 08:47 PM
INDEX PAGE:

Page generated in 0.53423405 seconds (48.28% PHP - 51.72% MySQL) with 49 queries.


FORUM DISPLAY:

Page generated in 0.18321705 seconds (67.25% PHP - 32.75% MySQL) with 30 queries.


SHOW THREAD:

Page generated in 0.40286696 seconds (77.49% PHP - 22.51% MySQL) with 76 queries.

someone expert can help me with this big problem? i have a huge amount of query and i can't install optimizing forum home by xenon because i'm a disaster :(
Xenon
03-23-2003, 08:59 PM
ouch, especially showthread is really bad...

remove hacks which affected this file.
it looks like you have a query in a loop there..
Kevorkian
03-23-2003, 09:03 PM
O_o oh my god, query in a loop? what does it mean? can i send you the respective file?
Xenon
03-23-2003, 09:04 PM
nope sorry i don't have enough time these days to do any private help..
Erwin
03-23-2003, 09:09 PM
Basically, you are showing something in the postbit of users that require a query for EACH user. The old Itemshop did this, as do other similar hacks that show up for each post in a thread.
Kevorkian
03-24-2003, 10:45 AM
no i have any itemshop installed :( these are the hack i've installed http://www.animesaga.altervista.org/forum/showthread.php?s=&threadid=2 i have the slowest forum of the community -___-''