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: Looking for profressional help optimizing CPG for large database  (Read 4406 times)

0 Members and 1 Guest are viewing this topic.

net

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 88

Hi,

I'm having some trouble with slow queries and i can't on my own figure out how to lessen the load on the sql server.

I've done all in my capability to lessen the load (removed comments, intermediate page, favorites, hit logging, static statistics updated through cronjob each night, removed keywords)

Still my sql show evidence of slow queries that i can't find. My gallery is "big" but not huge. I don't use users, i'm the only user. I do however have 500 000 high quality images, also i have around 5000 + albums and 200 + categories. I have lots of requests for someone experienced enough such as:

1. Make all statistics on the site update through cronjobs, even the ones calculating amount of images in album/categories. (Right now i only have the statistics on the front page update through a cronjob, the mod was for free on these boards.)
2. Remove / re-write the queries in includes.inc.php to improve performance. (if nessesary)
3. Install SEF Url support through apache mod_rewrite module and modify it so that the url output has -categoryname-albumname-whatever.html (SEF Url works fine on my apache setup, however i need someone to mod the default htaccess that comes with it to do the changes above.)
4. A better and smoother way to see recent updates through coppermine, right now i'm using "thumbnails.php?album=lastalb" which takes a long time to load if you have 5000 + albums.)
5. Change so that query sorting last updated album sorts the thumbnail for the album by ascending, which means, the last picture uploaded to the album should be the picture displayed, not the first one uploaded (which is default and unchangeable in coppermine)
6. If possible optimize SQL settings to suit my gallery better.

This is about it, price range would be 350$ or more depending on how much of this can be solved with ease.

Please reply to this thread if you're serious and want to get in contact.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged

net

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 88
Re: Looking for profressional help optimizing CPG for large database
« Reply #2 on: July 23, 2009, 10:05:14 am »

Sorry if i broke any rules Joachim, but you solved this issue for me in another thread. Ofcourse more optimizations could be done, but seeing how much performance i gained from the fix you helped me with in another thread i really don't need them done anytime soon.

For others that experience performance issues hosting huge amount of pictures see thread:
http://forum.coppermine-gallery.net/index.php/topic,60739.0.html

But note that this change will have this effect on your gallery:
Quote from: Joachim Müller
You'll loose the approval admin menu item. Doesn't hurt if you're the only uploader or if you haven't enabled admin approval for your groups.

Thanks for the help!
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.