Ok...I need some help here. My photo gallery is chewing crazy amounts of bandwidth and I need to figure this out. FAST.
From day 1, the parameters setup pertaining to uploaded pics both in size and dimensions were waaaay too high. So I fixed that now, but I'm stuck with a whole bunch of pictures that are far too big. Also....a few different variables dealing with caching were disabled, so I enabled them to help with bandwidth as well.
Is there a way that I can rebuild the database to downsize already uploaded pics?
I should say that the amount of bandwidth I stated that was used is for my whole website. Sorry about that.
But my stats are showing that the vast majority used seems to be coming from the photo gallery. I'm ready to turn the gallery off for a few days to make sure that my thoughts are correct, but I thought I'd ask a few questions 1st to see if you all have any ideas for me.
You can rebuild medium and thumbnail images in Admin => Scan Database if you have lowered those sizes to lower those image sizes. You can not rescan large images already uploaded as thats the image used to redo mediums and thumbnails. You need something to work with as a basis.
Anyway doing that should help. You can also restrict the gallery in registration options that only registered users can see the main images so guests only see thumbnails and have to register. This will cut down on bandwidth
You can also setup hotlinking stuff incase people are hotlinking your images elsewhere
Ok...I'm running the rebuild on thumbnails and mediums and it's giving me a whole bunch of messages saying "rebuilding". I'm assuming that's a good thing and it's now rebuilding already uploaded pics to the new size and dimension restrictions I put in place??
Okay well if that 25% script is showphoto and your showing large photos to everyone I can see the bandwidth being high. It really depends on how you set things up. What are your thumbnail medium and width height thresholds in admin upload options?
I'll just throw down some parameters that might lend into all this.
Thumbnail image max width and height in pixels 80
Max allowable image width in pixels 640
Max allowable image height in pixels 480
Trigger medium graphic height and width
An uploaded larger than this will create a medium image of this size. 600
Quality setting for resizing/thumbnails? 60
I'm not allowing members to upload video of any kind. Pics only.
Enable IP Cache Timeout
This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting Set to 5
Use photo view caching to reduce view update queries on high load sites?
Set this to YES if you want to enable the view caching code which caches photo view updates Set to yes
Use category cache?
On some larger sites, using the category cache can actually reduce performance. set to yes
Minutes to cache index page data for featured photos, statistics and PALs?
Number of minutes to cache information. Default is 10 minutes, 0 means no caching. set to 12
Those all sound fine so unless you have tons of guests viewing the gallery if your site is very busy I dont see anything wrong. your bandwidth will always be tons higher with a gallery versus a forum etc.