On my local test site (using
[PROGRAM] 4images Mobile Server) I have over 330k images.
4images is almost unmodified, with default settings. I had to disable random images feature, it would take about 10-20 sec for the home page to open when it was enabled.
The test was with 1 simulation connection, with admin account (PRINT_QUERIES enabled), cache disabled.
Home page:
Page generated in 1.697322 seconds with 8 queries, spending 1.584000 seconds doing MySQL queries and 0.113322 doing PHP things. GZIP compression disabledA category with 10k images and 30 images per page, first page:
Page generated in 0.529909 seconds with 7 queries, spending 0.369000 seconds doing MySQL queries and 0.160909 doing PHP things. GZIP compression disabledSame category, 30 images per page, last page:
Page generated in 0.557204 seconds with 7 queries, spending 0.399000 seconds doing MySQL queries and 0.158204 doing PHP things. GZIP compression disabledSame category, 3 images per page, first page:
Page generated in 0.462873 seconds with 7 queries, spending 0.366000 seconds doing MySQL queries and 0.096873 doing PHP things. GZIP compression disabledSame category, 3 images per page, last page:
Page generated in 0.498907 seconds with 7 queries, spending 0.401000 seconds doing MySQL queries and 0.097907 doing PHP things. GZIP compression disabledDetails page of the first image from same category:
Page generated in 0.615506 seconds with 10 queries, spending 0.527000 seconds doing MySQL queries and 0.088506 doing PHP things. GZIP compression disabledDetails page of the last image in same category:
Page generated in 0.696011 seconds with 10 queries, spending 0.533000 seconds doing MySQL queries and 0.163011 doing PHP things. GZIP compression disabledSearch page with 40 search results (30 images per page):
Page generated in 0.724453 seconds with 10 queries, spending 0.536000 seconds doing MySQL queries and 0.188453 doing PHP things. GZIP compression disabledSearch page with 4000 search results (30 images per page):
Page generated in 5.868750 seconds with 12 queries, spending 5.010000 seconds doing MySQL queries and 0.858750 doing PHP things. GZIP compression disabledwith 3 images per page:
Page generated in 5.182323 seconds with 9 queries, spending 5.058000 seconds doing MySQL queries and 0.124323 doing PHP things. GZIP compression disabledSearch page with 130000 search results (30 images per page):
Page generated in 7.661727 seconds with 12 queries, spending 6.864000 seconds doing MySQL queries and 0.797727 doing PHP things. GZIP compression disabledwith 3 images per page:
Page generated in 7.555225 seconds with 9 queries, spending 6.807000 seconds doing MySQL queries and 0.748225 doing PHP things. GZIP compression disabledChanging to second page (3 images per page):
Page generated in 2.334470 seconds with 8 queries, spending 2.106000 seconds doing MySQL queries and 0.228470 doing PHP things. GZIP compression disabledChanging to last page (3 images per page):
Page generated in 3.672184 seconds with 11 queries, spending 3.455000 seconds doing MySQL queries and 0.217184 doing PHP things. GZIP compression disabledI'm pretty sure on *unix system the results would be much better.
