Tested on a site with 16,637 products

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

Just tested this on my internal server.  Just a couple of quick checks.
Below is the info from the pages I tested (with a bit of info of what that page contains).

Show Category Counts = false
Sessions = mysql

Will try this again later with differant  Show Category Counts = true.

Also, I have made MAJOR changes to my tables, so my site is not standard by anymeans shape or form.

Anyways here are the results from 8 differant pages:
------------------------------------
index.php
-----------------------------------
OLD CODE
Parse Time: 2.543 s
Queries (count/total time/avg time):
53
2.296159863472 s
0.043323771008905 s 
------------------------------------
NEW CODE
Parse Time: 2.518 s
Queries (count/total time/avg time):
44
2.3764452934265 s
0.054010120305148 s 
------------------------------------
product_info.php/products_id/16633 (just a random product I picked)
------------------------------------
OLD CODE
Parse Time: 0.171 s
Queries (count/total time/avg time):
56
0.033632636070251 s
0.00060058278696878 s 
------------------------------------
NEW CODE
Parse Time: 0.256 s
Queries (count/total time/avg time):
39
0.12348258495331 s
0.0031662201270079 s 
------------------------------------
index.php/cPath/21  (cat with no products)
------------------------------------
OLD CODE
Parse Time: 1.954 s
Queries (count/total time/avg time):
43
1.7235897779465 s
0.040083483208057 s
------------------------------------
NEW CODE
Parse Time: 1.913 s
Queries (count/total time/avg time):
32
1.7882061004639 s
0.055881440639496 s 
------------------------------------
shopping_cart.php (adding product)
------------------------------------
OLD CODE
Parse Time: 1.859 s
Queries (count/total time/avg time):
46
1.7272621393204 s
0.037549176941747 s 
------------------------------------
NEW CODE
Parse Time: 1.854 s
Queries (count/total time/avg time):
36
1.722837805748 s
0.047856605715222 s
------------------------------------
index.php/cPath/22 (four sub cats no products)
------------------------------------
OLD CODE
Parse Time: 2.006 s
Queries (count/total time/avg time):
75
1.7455425262451 s
0.023273900349935 s
------------------------------------
NEW CODE
Parse Time: 2.014 s
Queries (count/total time/avg time):
61
1.760552406311 s
0.028861514857558 s 
------------------------------------
index.php/cPath/22_32 (one sub cat no products)
------------------------------------
OLD CODE
Parse Time: 2.372 s
Queries (count/total time/avg time):
72
2.2015860080719 s
0.030577583445443 s 
------------------------------------
NEW CODE
Parse Time: 2.298 s
Queries (count/total time/avg time):
56
2.04907310009 s
0.036590591073036 s 
------------------------------------
index.php/cPath/22_32_54 (no sub cats 7074 products)
------------------------------------
OLD CODE
Parse Time: 2.788 s
Queries (count/total time/avg time):
73
2.4281200170517 s
0.033261918041804 s 
------------------------------------
NEW CODE
Parse Time: 2.883 s
Queries (count/total time/avg time):
56
2.6896396875381 s
0.04802928013461 s 
------------------------------------
index.php/cPath/22_32_54/sort/2a/page/6 (items 101 - 120)
------------------------------------
OLD CODE
Parse Time: 2.807 s
Queries (count/total time/avg time):
73
2.503071308136 s
0.034288648056657 s
------------------------------------
NEW CODE
Parse Time: 2.796 s
Queries (count/total time/avg time):
56
2.5014184713364 s
0.044668186988149 s
------------------------------------
Hope this helps out, will post again with the results from other tests.
Also, sorry this is so long, but wanted the info to be easily readable.

Nicky