Is there a size limit on a Gallery site?

lisaannphillips

Joined: 2009-04-15
Posts: 8
Posted: Sun, 2010-11-28 19:59

Is there a maximum size that one Gallery site can be? Because I want to keep adding to my site, but hate to think that one day it will be maxed out and I can no longer add albums/pictures.

I currently have a Gallery 2 website, and it seems like as I add more and more albums some of the functions slow down. Once example is that I used to be able to put about 200 images in an upload directory on the local server and choose to add those images and it was no problem. Now it sees like I have to limit the amount of pictures I have it upload to about 50, or it chokes and never completes the upload process. Since the only thing that has changed with my site (unless something changed on the host) is the size of it.

Here is my current site, and the system info, showing DB info as well as the size of the gallery/g2data directory:

http://www.phillipszoogallery.com

Gallery URL = http://www.phillipszoogallery.com/gallery/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.14 cgi-fcgi
Webserver = Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database = mysqlt 5.1.52, lock.system=flock
Toolkits = ArchiveUpload, Exif, ImageMagick, Gd
Acceleration = none, none
Operating system = Linux terracan.websitewelcome.com 2.6.34.6 #90 SMP Tue Nov 23 04:53:16 CST 2010 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12 ( .NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 30
Rows in GalleryAccessSubscriberMap table = 8479
Rows in GalleryUser table = 2
Rows in GalleryItem table = 8477
Rows in GalleryAlbumItem table = 105
Rows in GalleryCacheMap table = 0

This shows the g2data directory is almost 2.5 gig

phillipszoogallery.com [~/www/gallery]# du -ks *
2484064 g2data

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2010-11-28 20:53
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2010-11-29 01:00
Quote:
I currently have a Gallery 2 website, and it seems like as I add more and more albums some of the functions slow down.

In addition to reading Dave's links. Uninstall EXIF and GD. Also check out these links:
http://codex.gallery2.org/Gallery2:ACL_Performance (don't use a lot of unique permissions, for example User Albums can be a problem on a large install too)

http://gallery.menalto.com/node/88074#comment-309218

I mention hardware in that last post. First you only have about 8500 images, that's not a lot, but does equal up to 85,000 files on the file system if you are using caching (which you should to keep performance up). Lots of files on the file system can slow things down, especially on oversold low-end shared hosts.

However, right now you're not using any caching, see Site Admin > Performance. Yes it'll mean more files on the file system, but it will make browsing Gallery faster. Also take a look at making more tweaks, dump the image frames or hack your theme to include that stuff to it's one less module and at least one less css file included. Of course you also have to look at if you have a ton of visitors or is it most just friends and family and maybe a couple visitors a week or day or even an hour. Then it might not be worth putting a lot of work into tweaking things other than what's been mentioned above.

It doesn't really seem slow to me, so if it seems slow at different times could be there's a high load on the web and/or database server.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here