Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Coppermine could use some optimization [site getting real slow]  (Read 3099 times)

0 Members and 1 Guest are viewing this topic.

athlonkmf

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 68
    • http://www.asianfanatics.net/
Coppermine could use some optimization [site getting real slow]
« 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?
Logged
My coppermine gallery with 35000 images: http://www.asianfanatics.net/
Another coppermine gallery with images over the 1MB http://dsample.kmfstudio.com

groonie

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Coppermine could use some optimization [site getting real slow]
« Reply #1 on: April 11, 2005, 09:14:15 am »

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

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 20 queries.