slow queries - photopost

RCA · September 26th, 2005, 12:03 PM

Hello,
a site with 82.000 images is giving some problems with mysql caused by photopost.

Some queries or index should be improved here.

This is query that use to go to slow queries log:

Code:

Content visible to verified customers only.

Chuck S · September 27th, 2005, 04:11 PM

Try out new 5.2 with cache code

RCA · September 27th, 2005, 04:22 PM

great, will update soon. Cache is good

Chuck S · September 27th, 2005, 04:23 PM

Cache is very good. Like half the number of queries and time sliced alot but cache speed also depends on size of site

glowinggal · November 9th, 2006, 09:56 PM

how'd you make out?

Chuck S · November 10th, 2006, 09:37 AM

5.5 has lots of performance enhancements over 5.2