Coppermine could use some optimization [site getting real slow]

[athlonkmf]

I have now a gallery with 80594 files in 1699 albums and 25 categories with 1072 comments viewed 1692427 times. Quite a large one and i'm starting to get major slowdowns from gallery. Esp the index page.
I've started the debuginfo and saw that coppermine is using count(*) and sum in the many queries and thus needed 60 seconds to complete it task (show the main page). actually Page generated in 52.937 seconds - 80 queries in 52.872 seconds.
80 queries that should be able to be cut down if there was good usage of joins.

As MySQL stated, you shouldn't use the db-server as a calculator.

For a small site this is not a problem, but when a gallery is getting large, there should be thoughts about this.

Maybe for 1.4, instead of count and sum, there can be a stats-table collecting the stats?

[groonie]

im interested in hearing comments on this post also.
what are your server specs athlonkmf?

[kegobeer]

Already being discussed.

http://forum.coppermine-gallery.net/index.php?topic=15653.0