Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Coppermine could use some optimization [site getting real slow]  (Read 3955 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.018 seconds with 19 queries.