Scalability of PHP image galleries

[leegold]

There are a lot of PHP image gallery scripts out there. I wondered what
would be the ones that would scale for very big collections and heavy use.
Hundreds of users maybe thousands of users at a time and huge DBs of images.
Provided I had the hardware...

If you cited some names or links - I'd like to investigate it for my own
personal techie interest.

Thanks

[Jim Michaels]

I hear you should recode whatever it is using mysqli functions and avoid
using variables injected into an SQL statement. use mysqli_prepare() and
its related functions to feed your parameters in. MySQL can then cache SQL
statements. whatever helps I guess.

"leegold" <go******@worldpost.com> wrote in message
news:1BRAf.11803$jd5.343@trnddc02...

There are a lot of PHP image gallery scripts out there. I wondered what
would be the ones that would scale for very big collections and heavy use.
Hundreds of users maybe thousands of users at a time and huge DBs of
images.
Provided I had the hardware...

If you cited some names or links - I'd like to investigate it for my own
personal techie interest.

Thanks

[Steve]

On Sun, 22 Jan 2006 20:06:21 +0000, leegold wrote:

There are a lot of PHP image gallery scripts out there. I wondered what
would be the ones that would scale for very big collections and heavy use.
Hundreds of users maybe thousands of users at a time and huge DBs of images.
Provided I had the hardware...

If you cited some names or links - I'd like to investigate it for my own
personal techie interest.

Thanks

It'll scale to orders of magnitude higher if you don't store the images
in the database... just save filenames.

[Manuel Lemos]

Hello,

on 01/22/2006 06:06 PM leegold said the following:

There are a lot of PHP image gallery scripts out there. I wondered what
would be the ones that would scale for very big collections and heavy use.
Hundreds of users maybe thousands of users at a time and huge DBs of images.
Provided I had the hardware...

If you cited some names or links - I'd like to investigate it for my own
personal techie interest.

The problem of image galleries is that they serve too many images at
once per page. This kills Web servers like Apache 1.x that need to fork
too many processes and that kills the database server if you use
persistent connections.

For serving too many images at once it is better to use a multithreaded
HTTP server like thttp. For the page scripts, you can use Apache as
usual. Read here for a more detailed explanation of the problem:

http://www.meta-language.net/metabas...ve-connections

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/