PDA

View Full Version : lots of queries ? is this bad ?



s2kinteg916
11-20-2003, 08:39 AM
i looked at photopost which is what im using and did a print function and it says

MySQL queries: 470
is that bad ? it goes up to as much as 505

isnt vb and ipb only like 15 queries ?

does this put alot of strain on a server ?

Westech
11-20-2003, 08:52 AM
I'm not sure how many queries would be too many for you. It depends on over how long of a time period that number of queries were made. It also depends on what kind of server your using and if it's shared with other users and sites.

A good way to see if this is straining your server would be to install phpsysinfo (phpsysinfo.sourceforge.net). Look at the server load as photopost is being used.

bugsy
11-23-2003, 09:48 PM
If you're worried about server overload, you could cache the content the query returns and refresh it every 6 hours or so. I use PHPCache_Lite. It's a small php class that does it for you.

s2kinteg916
11-25-2003, 07:10 AM
well i talked to the developers and they fixed it i had to many categories which caused alot of queries its down to around 14 now