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]

Re: Scalability of PHP image galleries

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" <goldtech@world post.com> wrote in message
news:1BRAf.1180 3$jd5.343@trndd c02...[color=blue]
> 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
>
>[/color]

[Steve]

Re: Scalability of PHP image galleries

On Sun, 22 Jan 2006 20:06:21 +0000, leegold wrote:
[color=blue]
> 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[/color]
It'll scale to orders of magnitude higher if you don't store the images
in the database... just save filenames.

[Manuel Lemos]

Re: Scalability of PHP image galleries

Hello,

on 01/22/2006 06:06 PM leegold said the following:[color=blue]
> 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.[/color]

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/metabase-faq.html#excessive-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/