unfortunately I struggle with my native language so what the link shows does not make sense to me. I am sure some of the others can though. btw if you want to provide a patch. https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices and welcome to the community.
========================= 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 4:02 AM: > 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 >>> >>> >
