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

Cryp2Nite <[email protected]> 29 Jul 2003 14:12:53 -0000
Newsgroups gmane.comp.web.oscommerce.suggestions
Message-ID <2e1704fe9b050caba46e45687fedcc19@osCommerce-Forums>
This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=203779#203779
----------------------------------------------------------------

Thanks for taking the time to look at this.

[quote="jchasick"]your demo times look fairly accurate compared to the limited testing i have done so far
[/quote]
Great, I am/was hoping someone with a big store to give this code a try and report back.
Could you give me an idea what size store your  setup has and maybe some info on your hardware config?

[quote="jchasick"]
it is an amazing speed difference
[/quote]
That is kind of what I expected, I did some (really fast and probably not too accurate) tests on a stock install with maybe 9 extra categories and products nested three levels deep. And the performance gain went up to well over 60% on some pages :D

[quote="jchasick"]
now what will it take to make navigation work?[/quote]
Well, probably for me to finish the code. To do that I would have to be convinced someone is going use this.
But, as I said in an other thread it's of limited use to me as I am not expecting any performance issues for the sites I am likely to setup in the near future.
My thought is that it would have to be included in osC proper, as this is not a change in functionality but a dfiferent aproach for standard osC functonaity. 
But  I don't know what the right approach is. What I [b]do[/b] know that I haven't been around long enough to earn enough brownie points to have my claim taken at face value :). That's why I am trying to get some favourable performance numbers, to make sure I am not wasting everybodies time. And then to ask someone in the core team to have a look at this thread and ask for their thoughts.  


Cheers,
Rob