RE: BIG (up to 45%) performance increase for categorybox.php

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

I owe everyone an apology
[b]I am a moron, I am sorry[/b] 

So there, with that out of the way: The last tarball some of you downloaded was doing everything it should do except reporting the benchmark figures, unless you turned on sql query logging.  :oops: 

To make up for this stupidity I have uploaded a new version of the code and have setup a demonstration server online.

So, for the downloads
[i]The new code:[/i]
http://www.cryp2nite.nl/improved_catalog.tar.gz
[i]Previous version:[/i]
http://www.cryp2nite.nl/improved_catalog-0.2.tar.gz


This code is the same (except for the SQL connection settings) as the demo links below.

[b]Demo links:[/b]
[i]Original code (Today's CVS)[/i]
http://www.cryp2nite.nl/oscdemo/catalog_ori

[i]New code[/i]
http://www.cryp2nite.nl/oscdemo/catalog_new

For the performance improvement look at the reported, number of queries and the total time spent doing these queries.
Parse time is probably not a very useful, as I have paid no particular attention to performance for the rendering code and the generated page is showing too much information, but as you can see all required information to construct a decent menu is there.

I hope I can still convince some of you to give it another shot and try the code on their setups. 

Cheers,
Rob

P.S.: For anyone not downloading the code, there's a README with some instructions on how to compare the two versions of the code. It might be useful because the category box of the new code is not functional and navigation is not possible, it's also avalable online:
http://www.cryp2nite.nl/oscdemo/README.TXT

Most should be pretty obvious though.