Tested on a site with 16,637 products

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=205205#205205
----------------------------------------------------------------

OK, ran it with Show Category Counts = true.
Site evironment firstly though:

Apache 1.3.26
PHP 4.2.3
MySQL 3.23.39
mod_ssl 2.8.10
OpenSSL 0.9.6g
Red Hat Linux 7.1 (Seawolf)

In this test environment I have 16,637 products residing inside 38 categories.

Same 8 pages tested as before:

------------------------------------
index.php
------------------------------------
OLD PAGE
Parse Time: 3.065 s
Queries (count/total time/avg time):
129
2.7980867624283 s
0.021690595057584 s
------------------------------------
NEWPAGE
Parse Time: 2.959 s
Queries (count/total time/avg time):
62
2.8077870607376 s
0.045286888076413 s
------------------------------------
product_info.php/products_id/16633 (just a random product I picked) 
------------------------------------
OLDPAGE
Parse Time: 0.953 s
Queries (count/total time/avg time):
148
0.79794108867645 s
0.0053914938424085 s 
------------------------------------
NEWPAGE
Parse Time: 0.667 s
Queries (count/total time/avg time):
57
0.42388212680817 s
0.0074365285404941 s 
------------------------------------
index.php/cPath/21 (cat with no products) 
------------------------------------
OLD PAGE
Parse Time: 2.476 s
Queries (count/total time/avg time):
121
2.2291589975357 s
0.018422801632526 s
------------------------------------
NEW PAGE
Parse Time: 2.346 s
Queries (count/total time/avg time):
50
2.1092392206192 s
0.042184784412384 s 
------------------------------------
shopping_cart.php (adding product) 
------------------------------------
OLD CODE
Parse Time: 2.378 s
Queries (count/total time/avg time):
121
2.2336277961731 s
0.01845973385267 s 
------------------------------------
NEW CODE
Parse Time: 2.255 s
Queries (count/total time/avg time):
61
2.1152994632721 s
0.03467704038151 s 
------------------------------------
index.php/cPath/22 (four sub cats)
------------------------------------
OLD CODE
Parse Time: 2.918 s
Queries (count/total time/avg time):
163
2.6479508876801 s
0.01624509747043 s 
------------------------------------
NEW CODE
Parse Time: 2.381 s
Queries (count/total time/avg time):
79
2.2278785705566 s
0.028200994564008 s 
------------------------------------
index.php/cPath/22_32 (one sub cat)
------------------------------------
OLD CODE
Parse Time: 3.454 s
Queries (count/total time/avg time):
162
3.2893352508545 s
0.020304538585522 s 
------------------------------------
NEW CODE
Parse Time: 2.699 s
Queries (count/total time/avg time):
74
2.4421941041946 s
0.033002623029657 s 
------------------------------------
index.php/cPath/22_32_54 (7074 products)
------------------------------------
OLD CODE
Parse Time: 3.823 s
Queries (count/total time/avg time):
163
3.5041168928146 s
0.02149764964917 s 
------------------------------------
NEW CODE
Parse Time: 3.173 s
Queries (count/total time/avg time):
74
2.8674243688583 s
0.038748977957545 s 
------------------------------------
index.php/cPath/22_32_54/sort/2a/page/6 (items 101 - 120)
------------------------------------
OLD CODE
Parse Time: 3.948 s
Queries (count/total time/avg time):
163
3.5201981067657 s
0.021596307403471 s
------------------------------------
NEW CODE
Parse Time: 3.196 s
Queries (count/total time/avg time):
74
2.7829014062881 s
0.037606775760651 s 


Hope this helps you out.  Great job!

Nicky