are you sure you are not referring to 1 million products. I run in the real world over 100,000 products. I have approx 18 top categories with 3-10 levels of sub categories. if your see 1,000,000 categories that way then it is feasible. I use automated updating from my suppliers to keep thing up-to-date. these updates happen every 24 for prices new and obsolete products. availability is as often as 15 min. The average Cpu usage during these operations is about 15% of a 1.6ghz Cpu with enough RAM to not use the swap file. the peak cpu usage is about 75% when the scheduled services and large imports (1 gig data) are happening.
========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Michal Cukierman sent the following on 4/30/2010 1:51 AM: > Hello, > > Thank you for your quick response. Regarding your question about real world > applications: > Ecommerce: > http://www.rockauto.com/ > http://allegro.pl/ > > There are applications that holds > 1 000 000 categories. > In a PLM industry it's also very common to have a couple of milions of > objects (consider the complexity of a train or a plain for example). > > The point of my post was not a fix, but the implementation of the find root > category method. > I think that you should avoid such a code. You have got great database layer > (great possibility to improve performance) so it would be great to utilize > it as much as it's possible. > I really like Ofbiz application thats why I try to give you my input. > > Once again thank you for the response and for the link you send me. I will > come back with the better solution after studing the datamodel. > > Regards, > Michał Cukierman > > > > W dniu 30 kwietnia 2010 10:11 użytkownik Jacques Le Roux < > jacques.le.r...@les7arts.com> napisał: > >> For instanc >