forum.coppermine-gallery.net

No Support => General discussion (no support!) => Topic started by: athlonkmf on January 02, 2005, 08:05:44 pm

Title: Coppermine could use some optimization [site getting real slow]
Post by: athlonkmf on January 02, 2005, 08:05:44 pm

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?

Title: Re: Coppermine could use some optimization [site getting real slow]
Post by: groonie on April 11, 2005, 09:14:15 am

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

Title: Re: Coppermine could use some optimization [site getting real slow]
Post by: kegobeer on April 11, 2005, 12:41:11 pm

Already being discussed.

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