PP 5.21: Performance Issues

[Chuck S]

I would suggest you download 5.3 as there have been changes to the 5.3 showphoto that might be in your best interest

[mtha]

yes, I did install 5.3, and apply all Michael performance suggestion, however, 1-2 second per page generation is still high to me, on a beta album, one online user (being me).

maybe I will remove some queries, or add to cache.

for example, for me, the query to check awaiting for moderation images (SELECT id FROM photos WHERE approved=0) is taking too long. maybe I will consider removing it, or adding to cache

[Chuck S]

admin will have more queries than a regular user yes.