Hi, Yes I am sure that I am talking about categories. See the example of rockauto or any other automotive ecommerce shop: 200 brands x 20 years x 10 models x 5 engine types x 12 part groups (interior, engine, exterior, accesories) 200 x 20 x 10 x 5 x 12 = 2 400 000. Its only an example. Software like Alldata or PartExpert generates much more cateogies. What about American car parts association?
Anyway this is not a case. It's not a point to discuss. Please consider the application with 10 000 categories and select * from statement running concurently. Please try to update some category with ReadCommited isolation level (As you use as default). This disscusion does not make sens. My question was: - What is the way of using primary_parent_category? - Is my fix ok? - In addition I pointed you a mistake in your code (which kills my application and is a performance issue) - I said that i will prepare a patch as soon as I will find whats around Whats you response: - read our books that could be bought here - your fix is a bad one, no suggestion how to improve it - our code is a good one and we don't need to change it. As ofbiz works on my laptop - after such constructive responses I don't really want to sent you my patches (just to show you, not saying that you are going to commit it) All I wanted to do from my side is to give you my input and a little help. After all, I still can't understand why selecting even 1000 record from database if we need to use 10 is a good solution. Regards, Michał W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman <[email protected]>napisał: > 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 < > > [email protected]> napisał: > > > >> For instanc > > > > >
