Sorry for sending you another message but I have just found an interesting link:
http://allegro.pl/category_map.php It's a category map. If you want to use OFBiz in real commercial systems (not for SMB industry) you need to face such use cases. Regards, Michał Cukierman W dniu 30 kwietnia 2010 12:56 użytkownik Michal Cukierman <[email protected]>napisał: > 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 >> > >> >> >> >
