Yes, it is a good example. I've done a project with car parts so i'm pretty familiar with the millions of categories :)
However there is a lot of room for optimization. In ofbiz you could add a product into many categories so you don't have to create a category "Brake-wheel hub" many times for each brand. One additional feature of ofbiz that could be used here is the product manufacturer party - manufacturer_party_id, so you don't have to create each vendor as a category. Of course you are free to do it if it's easier for you :) Ofbiz data model is actually perfect for car or any types of parts, because it's very flexible. You could associate products and using different associations, for example: compatible with, replaceable by, required or anything else ( product_assoc_type table ) Cheers, Deyan On Fri, 2010-04-30 at 13:02 +0200, Michal Cukierman wrote: > 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 > >> > > >> > >> > >> > >
