Performance - or rather missing performance

mol

Joined: 2007-08-05
Posts: 15
Posted: Mon, 2009-08-17 20:35

After a little playing around in the weekend with a few photos only, I tried tonight to import approximately 200 photos in average 4 MB each. Holy cow, this killed my dedicated server completely! I will say that it is completely impossible to use as for example loading 16 thumbnails takes 30-60 seconds (does it really generate them from scratch each time?) and the slideshow simply no longer works.

I have several thousand photos, so this was just a little corner of what I intend to import. But it seems as if I need to invest in some water cooled beast to run a small gallery :(

Did run the database optimization after importing, and changed the uri setting in config.php to ''. If this worked at all, it was only on the last decimals. I would say that it is useless the way it works now.

Unless there are some obvious performance improvement areas, I must say that G2 is the worst performance sucker I have ever tried.

Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.4.9 apache
Webserver = Apache/1.3.41 (Unix) PHP/4.4.9 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
Database = mysqlt 4.1.22-standard, lock.system=flock
Toolkits = Gd, Exif, SquareThumb, Thumbnail
Acceleration = none, none
Operating system = Linux healthandhost.servers.rbl-mer.misp.co.uk 2.6.9-67.0.4.ELsmp #1 SMP Sun Feb 3 07:08:57 EST 2008 i686
Default theme = carbon
gettext = enabled
Locale = da_DK
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 8
Rows in GalleryAccessSubscriberMap table = 230
Rows in GalleryUser table = 2
Rows in GalleryItem table = 228
Rows in GalleryAlbumItem table = 7
Rows in GalleryCacheMap table = 0

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 6138
Posted: Mon, 2009-08-17 21:20

Well, GD is a total memory hog try imagemagick.
Also if you don't need exif, its a resource hog as well.

Quote:
does it really generate them from scratch each time?

Nope just once.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 22892
Posted: Tue, 2009-08-18 04:33

http://codex.gallery2.org/Gallery2:Performance_Tips

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
mol

Joined: 2007-08-05
Posts: 15
Posted: Wed, 2009-08-19 07:41

I started a search sometime ago to find a replacement for my old Singapore gallery (http://www.sgal.org). The main objective for me was to get a gallery with exif support. However, I must conclude that this program where development was discontinued back in 2006, in almost all respects are 10-folds better than Gallery, Coppermine and all the other "big" programs. No performance problems, no timeconsuming administration, no mysterious errors, but a simple nice-looking gallery that works with speed like a Ferrari, and that everyone can find out how to use. So I have stopped further search for 2alternatives - they don't exist, and just hope someday some people would take up the development of this wonderfuld package again. Did I mention that the complete install file is 284KB. Try to compare this to the other monster packages on the market :)
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 6138
Posted: Wed, 2009-08-19 11:52

Have you compared Gallery3?
Or are you just here to pimp sgal?

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
mol

Joined: 2007-08-05
Posts: 15
Posted: Wed, 2009-08-19 12:12

No, haven't tried G3, but have noticed at least that - for the time being - it is lighter than G2. But have my doubt's that it will make any difference. Also this is beta, so I suspect it will be even worse to implement than G2.

I am not here to pimp anything, although I hope that someone might start up Singapore again. I was much in doubt whether I should write the above or not, but decided to do for two reasons: 1) To possibly open some developers eyes for what photogalleries are all(most) about, namely a facility to show ones photos without neccesarily tons of bells and whistles and a watercooled server, and b) to hopefully promote Singapore to get this project back on the stage.

I assume that many people like a gallery as G2, but also a lot of people want to keep something simple just that: Simple! May I suggest that you guys have a look at Singapore, and then you would probably be surprised to learn how much you get for 284 kb installed software (guess this is less than the simplest modul/theme for G2). And my honest opinion is that except for the missing exif this product is serving its purpose many times better than all the bells and whistle galleries together.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Wed, 2009-08-19 16:01

G3 is very easy to install. It's lighter and should stay that way than G2. It also doesn't use an "image firewall" so there's a performance bump right there. The permission system is a bit different as well to make things lighter. You can only assign permissions to groups (not users) and to albums (not individual items/photos)

There's a huge number of other changes. G3 is written from the ground up, and completely different than G2.

If you like sgal so much better, then stick with it. Gallery isn't being developed to copy some other work. From the brief demo and what I've read about sgal, I'd be very suspect that it can support huge (100,000s or millions of photos and users). It appears to constantly read from directories and files in the filesystem as people are browsing. But I'd have to install it to be sure. It looks like it really compares/competes with G1, which also does not scale well due to everything being stored in flat files and not in a database.

If you don't have a huge install or tons of visitors and don't need/want a database stick with sgal/G1/Jallery. But if you want/need advanced features and a strong support team. Well there's Gallery :)

Quote:
Singapore to get this project back on the stage.

So you are here pimping Singapore. Well, you're preaching to the wrong choir :)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
mol

Joined: 2007-08-05
Posts: 15
Posted: Thu, 2009-08-20 10:08
nivekiam wrote:
From the brief demo and what I've read about sgal, I'd be very suspect that it can support huge (100,000s or millions of photos and users). It appears to constantly read from directories and files in the filesystem as people are browsing. But I'd have to install it to be sure. It looks like it really compares/competes with G1, which also does not scale well due to everything being stored in flat files and not in a database.
quote]
I can only say that uploading a little over 200 photos made my Gallery2 loose breath completely. Every 10th thumbnail didn't show, so a quite disappoiting experience. My current +5000 photos in Singapore (all in full size 3-5 MB each) shows lightning fast, and no thumbnails are ever missing. Very few people would need millions of photos I guess. Have to add that Singapore displays a lower resolution jpg, but has a link to the full size images, so any users needing the full resolution can grap this. Only perhaps 1-2 times per year I am looking a bit in the administration module, but that is really not needed. It runs fully automatic and all my friends and family can with a delay of a couple of hours (my choice of ftp upload intervals) see the exact same photos that I have on my PC's harddisk. Get a loto of positive comments I have to add :)