Server load compared to gallery size Server load compared to gallery size
 

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]

Main Menu

Server load compared to gallery size

Started by Hercules25, March 31, 2012, 06:33:41 PM

Previous topic - Next topic

0 Members and 3 Guests are viewing this topic.

Hercules25

Before I hosted my site on a shared hosting account.
After a while my gallery slowly grew and contained 45,000 photos.
My host kicked me out because they claimed I was lagging their server to much.
I moved to a VPS (512MB) and things went on fine.
As a precaution I started a new gallery after 4 years and allmost 50K photos thinking I would improve the server load.
Gallery only gets into trouble now on days with 100K+ pageviews so I'm looking for 1 new server with 4GB memory and a faster CPU.
I'm also thinking of hiring somebody that can merge my 2 galleries so there will be only one (updating multiple galleries everytime sucks).
My question: if a gallery of 50,000 photos generates a theoretical server load of 100, will a gallery of 100,000 pics generate a server load of something like 120, 150, 200, 400 or 1,000?
Current galleries can be viewed here: http://www.kuikens.com/pictures/index.php & http://www.kuikens.com/photos/index.php (Yes I'll update to 1.5.20 soon)

ΑndrĂ©

To be honest, I don't know. Of course database queries will be slower the more rows a table contain, but I never checked the actual load. To increase performance, please read http://documentation.coppermine-gallery.net/en/performance.htm

Stramm

What Do you mean with this numbers? 100, 120 150. All I can tell you: it depends ;)
Not only on the number of pics but even more albums and categories. Also the number of users and the comment count may be of influence. If a server is at its max and it's starting to swap you can forget about it and need to find a better one. That new one may be loaded by maybe only 10-20%. That's what I've experienced with a 100k pic gallery.