Pros & Cons of Image Gallery using DB?

**Skipdawg** · October 19th, 2005, 4:55 PM

I'm playing with the idea of putting up a image gallery. Duel purpose for personal use and for some family and friends to share images and pics. Not really sure just how big but small to start for sure.

What are the pros and cons of having a image gallery use a the data base (MySQL) verses not using it.

I am looking at these so far.

Those that use the DB
Coppermine
Gallery 2
WEBalbum
Those that do not use the DB
SPGM (Simple Picture Gallery Manager)
MG2
DAlbum

I've never messed with a image gallery so totally new to me.
Looking at something simple but not to limited to where a small comment can be posted with the image and maybe make different pages like one for me and another for my brother an so forth.

**David** · October 20th, 2005, 7:43 AM

I'm not really sure what the pros and cons would be of the information storage vs. the pros and cons of the software itself. Personally, I prefer Coppermine. Gallery is a great on as well. They are both pretty easy to use.

**Skipdawg** · October 22nd, 2005, 4:12 PM

Thanks. Guess I'll have to inquire on this more else where.

**mr_fern** · October 24th, 2005, 9:00 AM

Databases tend to carry overhead for making connections, and if you choose persistent connections to avoid the continuous connection making, too much traffic could result in you reaching the limit the database is set on number of connections. Generally this isn't much a problem though, unless it gets a decent amount of traffic volume.

**Skipdawg** · October 24th, 2005, 1:44 PM

Thank you mr_fern

October 19th, 2005, 4:55 PM	#1 (permalink)
Skipdawg Insanely Super #1 Joined in Jul 2005 Lives in Northwest USA 4,154 posts Gave thanks: 39 Thanked 78 times	Pros & Cons of Image Gallery using DB? I'm playing with the idea of putting up a image gallery. Duel purpose for personal use and for some family and friends to share images and pics. Not really sure just how big but small to start for sure. What are the pros and cons of having a image gallery use a the data base (MySQL) verses not using it. I am looking at these so far. Those that use the DB Coppermine Gallery 2 WEBalbum Those that do not use the DB SPGM (Simple Picture Gallery Manager) MG2 DAlbum I've never messed with a image gallery so totally new to me. Looking at something simple but not to limited to where a small comment can be posted with the image and maybe make different pages like one for me and another for my brother an so forth. __________________

October 22nd, 2005, 4:12 PM	#3 (permalink)
Skipdawg Insanely Super #1 Joined in Jul 2005 Lives in Northwest USA 4,154 posts Gave thanks: 39 Thanked 78 times	Thanks. Guess I'll have to inquire on this more else where. __________________

October 24th, 2005, 9:00 AM	#4 (permalink)
mr_fern All Ur Base R Belong 2 Us Excelling Contributor Joined in Feb 2005 Lives in Vegas & New York 824 posts Gave thanks: 2 Thanked 6 times	Databases tend to carry overhead for making connections, and if you choose persistent connections to avoid the continuous connection making, too much traffic could result in you reaching the limit the database is set on number of connections. Generally this isn't much a problem though, unless it gets a decent amount of traffic volume. __________________ Nobody doing nothing

October 24th, 2005, 1:44 PM	#5 (permalink)
Skipdawg Insanely Super #1 Joined in Jul 2005 Lives in Northwest USA 4,154 posts Gave thanks: 39 Thanked 78 times	Thank you mr_fern __________________

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)