PDA

View Full Version : Huge galleries


omidvd
April 17th, 2008, 03:35 AM
hi,

if any photopost users have a gallery with over 100,000 pictures please contact me, i have a few questions regarding performance.

Best,
Omid.

Astaran
April 17th, 2008, 04:50 AM
We've about 130.000 images at the moment. A more important factor for performance are the number of categories and albums.

omidvd
April 17th, 2008, 04:54 AM
good thanks! few questions:
1. what is the link, would be honored to visit.
2. what php version are u using? we are using 5.2.5 CGI
3. what is the layout of servers? how many, how many CPU's etc. we are usign 2 servers, one for the DB, and one for the IIS. 2 CPU's per machine, upgrading to 4.

thanks lot.

Astaran
April 17th, 2008, 04:59 AM
1. http://fotogalerie.herr-der-ringe-film.de
2. PHP 5.2.5 fgci, on FreeBSD
3. Basically the same. We've a database server and a webserver. Biggest difference probably is that we're using memcache to cache the user's permission. That's the biggest bottleneck at the moment if you have a large number of categories.

omidvd
April 17th, 2008, 05:04 AM
your page is generated in 0.88100 seconds with 3 queries, how did u add that comment?

another difference is the random pictures we add 30 in the index page. and no caching - with out this - i the load time is minimal.

thanks.

Astaran
April 17th, 2008, 05:13 AM
You can enable that output by modifying pp-inc.php. Search for $showsqldebug and set it to 1.

You'll have to use caching to get fast page generation times.

omidvd
April 17th, 2008, 05:19 AM
thanks!