slow queries - photopost
 

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:

Try out new 5.2 with cache code ;)

great, will update soon. Cache is good :)

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

how'd you make out?

5.5 has lots of performance enhancements over 5.2