I am a PLM consultant interested in Open source projects. I am interested in
Ofbiz as a application framework, as well as the Fully flaged ERP system. I have to say that it has a lot of great solutions (i.e. modularity and small amount of code). Please forgive me if my question will be stupid as I have downloaded the Ofbiz sources today and I am quite new to the subject. So lets go to the point: In the line 96 (around, depending on svn version) of the class CategoryWorker of the products component there is a line: .. Collection<GenericValue> allCategories = delegator.findList("ProductCategory", null, null, null, null, false); .. Before I started to implement my solution using ofbiz I wanted to make some test, especialy on large amounts of data. So far I have got 1 000 000 categories in my database and after selecing: Choose Top Category <https://localhost:8443/catalog/control/ChooseTopCategory>action from the catalog management I run out of memory (4 GB of Xmx). I was considering why do we have to select all ( one milion!) records from the database if we want to choose only several of them? I have seen that you use PRODUCT_CATEGORY_ROLLUP table to keep the parent-child relations between categories. I understand that there is a need of having many to many relation. But besides we also have Many to one relation: primary parent category - child categories, shouldn't we consider those as well while selecting the ROOT objects? My solution was preaty trivial I have changed the line 96 in the mentioned class to: Collection<GenericValue> allCategories = delegator.findList ("ProductCategory", EntityCondition.makeCondition("PRIMARY_PARENT_CATEGORY_ID", null), null, null, null, false); Is it a good solution? If it's not - I will find another way (some join etc.), because from my point of view - selecting one milion objects if we need a couple of them can be done by RDMS in almost realtime. Please correct me if I am wrong. I can be wrong. Best Regards, Michał Cukierman |
Administrator
|
You are too quick with your assumptions. For instance did you test your change with the OOTB values and without? If you had done so
you would have found that they don't give the same result. I suggest to have a look at the p.71-75 of the data model reference book https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books And at large to read this book before making any new assumptions. This does not mean that your use case should not be more thought about... But one million categories, is this modeling something real in our world? Jacques Michal Cukierman wrote: > I am a PLM consultant interested in Open source projects. I am interested in > Ofbiz as a application framework, as well as the Fully flaged ERP system. I > have to say that it has a lot of great solutions (i.e. modularity and small > amount of code). > Please forgive me if my question will be stupid as I have downloaded the > Ofbiz sources today and I am quite new to the subject. > > So lets go to the point: > > In the line 96 (around, depending on svn version) of the class > CategoryWorker of the products component there is a line: > > .. > Collection<GenericValue> allCategories = > delegator.findList("ProductCategory", null, null, null, null, false); > .. > > Before I started to implement my solution using ofbiz I wanted to make some > test, especialy on large amounts of data. > So far I have got 1 000 000 categories in my database and after > selecing: Choose > Top Category <https://localhost:8443/catalog/control/ChooseTopCategory>action > from the catalog management I run out of memory (4 GB of Xmx). > > I was considering why do we have to select all ( one milion!) records from > the database if we want to choose only several of them? > > I have seen that you use PRODUCT_CATEGORY_ROLLUP table to keep the > parent-child relations between categories. I understand that there is a need > of having many to many relation. > But besides we also have Many to one relation: primary parent category - > child categories, shouldn't we consider those as well while selecting the > ROOT objects? > > > My solution was preaty trivial I have changed the line 96 in the mentioned > class to: > > Collection<GenericValue> allCategories = delegator.findList > ("ProductCategory", > EntityCondition.makeCondition("PRIMARY_PARENT_CATEGORY_ID", null), null, > null, null, false); > > Is it a good solution? If it's not - I will find another way (some join > etc.), because from my point of view - selecting one milion objects if we > need a couple of them can be done by RDMS in almost realtime. > > Please correct me if I am wrong. I can be wrong. > > > Best Regards, > Michał Cukierman |
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 < [hidden email]> napisał: > For instanc |
In reply to this post by Jacques Le Roux
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 <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 < > [hidden email]> napisał: > >> For instanc > |
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 <[hidden email]>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 > < > 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 < > > [hidden email]> napisał: > > > >> For instanc > > > > > |
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 <[hidden email]>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 <[hidden email]>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 >> < >> 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 < >> > [hidden email]> napisał: >> > >> >> For instanc >> > >> >> >> > |
In reply to this post by Michal Cukierman
to address your basic concern the solution would be to load only the
ID's instead of the complete data for each row. this is a minor change to the find call. give that a try. List<GenericValue> org.ofbiz.entity.Delegator.findList(String entityName, EntityCondition entityCondition, Set<String> fieldsToSelect, List<String> orderBy, EntityFindOptions findOptions, boolean useCache) ========================= 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 <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Michal Cukierman sent the following on 4/29/2010 12:30 PM: > I am a PLM consultant interested in Open source projects. I am interested in > Ofbiz as a application framework, as well as the Fully flaged ERP system. I > have to say that it has a lot of great solutions (i.e. modularity and small > amount of code). > Please forgive me if my question will be stupid as I have downloaded the > Ofbiz sources today and I am quite new to the subject. > > So lets go to the point: > > In the line 96 (around, depending on svn version) of the class > CategoryWorker of the products component there is a line: > > .. > Collection<GenericValue> allCategories = > delegator.findList("ProductCategory", null, null, null, null, false); > .. > > Before I started to implement my solution using ofbiz I wanted to make some > test, especialy on large amounts of data. > So far I have got 1 000 000 categories in my database and after > selecing: Choose > Top Category <https://localhost:8443/catalog/control/ChooseTopCategory>action > from the catalog management I run out of memory (4 GB of Xmx). > > I was considering why do we have to select all ( one milion!) records from > the database if we want to choose only several of them? > > I have seen that you use PRODUCT_CATEGORY_ROLLUP table to keep the > parent-child relations between categories. I understand that there is a need > of having many to many relation. > But besides we also have Many to one relation: primary parent category - > child categories, shouldn't we consider those as well while selecting the > ROOT objects? > > > My solution was preaty trivial I have changed the line 96 in the mentioned > class to: > > Collection<GenericValue> allCategories = delegator.findList > ("ProductCategory", > EntityCondition.makeCondition("PRIMARY_PARENT_CATEGORY_ID", null), null, > null, null, false); > > Is it a good solution? If it's not - I will find another way (some join > etc.), because from my point of view - selecting one milion objects if we > need a couple of them can be done by RDMS in almost realtime. > > Please correct me if I am wrong. I can be wrong. > > > Best Regards, > Michał Cukierman > |
In reply to this post by Michal Cukierman
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 <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 > <[hidden email]>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 <[hidden email]>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 >>> < >>> 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 < >>>> [hidden email]> napisał: >>>> >>>>> For instanc >>> >>> > |
In reply to this post by BJ Freeman
BJ,
I also am new to ofbiz and am trying to learn how to use it. I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products. I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories. I have a couple of questions: -Can a category be used in more than one Catalog? -Can a category have more than one parent? It looks like the answer is "no" but just making sure. thanks, Paul BJ Freeman wrote: > 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 > <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 < >> [hidden email]> napisał: >> >> >>> For instanc >>> > > > |
In reply to this post by BJ Freeman
Yes to both.
catalog is basically tying product, catagories and searches together. so you can have multiple catalogs, with any or all products and categories already defined. ========================= 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 <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Paul Abernathy sent the following on 4/30/2010 4:54 AM: > BJ, > > I also am new to ofbiz and am trying to learn how to use it. I couldn't > help noticing this discussion because I wanted to do the same thing - > set up a hierarchy of categories for products. I was just going through > the business setup guide located at > https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide > and towards the end it discusses how to set up categories. I have a > couple of questions: > > -Can a category be used in more than one Catalog? > -Can a category have more than one parent? It looks like the answer is > "no" but just making sure. > > thanks, > > Paul > > BJ Freeman wrote: >> 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 >> <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 < >>> [hidden email]> napisał: >>> >>> >>>> For instanc >>>> >> >> >> > > |
In reply to this post by Michal Cukierman
A few of points:
- CategoryWorker.getCategoriesWithNoParent(...) is a seldom used method and certainly not used in the eCommerce application. If would be better to understand properly how OFBiz navigates Categories and then worry about the performance of that. I'm quite sure that method could be improved though. - A structure of 1 million categories is in my opinion probably not a good one, my guess is that they may have more categories than parts and is probably indicative of the limitations of the software they're using rather than OFBiz's limitations. OFBiz provides many methods for navigating, filtering and searching around products. Are there going to bottlenecks when you have millions of products? Absolutely, but I'm quite sure they could be overcome fairly easily. - I don't believe primaryParentCategory can be used in this case, it is merely additional information that is not guaranteed to be present. I would either create a view entity that forms an outer join between ProductCategory and ProductCategoryRollup (although that may not be performant enough), or otherwise I would introduce some stronger business rules that prevent categories being created if the don't have a parent (either parent category or catalog). Regards Scott HotWax Media http://www.hotwaxmedia.com On 30/04/2010, at 11:02 PM, 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 > <[hidden email]>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 <[hidden email]>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 >>> < >>> 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 < >>>> [hidden email]> napisał: >>>> >>>>> For instanc >>>> >>> >>> >>> >> smime.p7s (3K) Download Attachment |
In reply to this post by Paul Abernathy
Hello List:
If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com Regards, Ruth ---------------------------------------------------- Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" [hidden email] Paul Abernathy wrote: > BJ, > > I also am new to ofbiz and am trying to learn how to use it. I > couldn't help noticing this discussion because I wanted to do the same > thing - set up a hierarchy of categories for products. I was just > going through the business setup guide located at > https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide > and towards the end it discusses how to set up categories. I have a > couple of questions: > > -Can a category be used in more than one Catalog? > -Can a category have more than one parent? It looks like the answer > is "no" but just making sure. > > thanks, > > Paul > > BJ Freeman wrote: >> 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 >> <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 < >>> [hidden email]> napisa³: >>> >>> >>>> For instanc >>>> >> >> >> > > |
Hi Ruth,
This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising? Thanks Scott On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: > Hello List: > If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com > > Regards, > Ruth > ---------------------------------------------------- > Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" > [hidden email] > > Paul Abernathy wrote: >> BJ, >> >> I also am new to ofbiz and am trying to learn how to use it. I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products. I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories. I have a couple of questions: >> >> -Can a category be used in more than one Catalog? >> -Can a category have more than one parent? It looks like the answer is "no" but just making sure. >> >> thanks, >> >> Paul >> >> BJ Freeman wrote: >>> 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 >>> <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 < >>>> [hidden email]> napisa³: >>>> >>>> >>>>> For instanc >>>>> >>> >>> >>> >> >> smime.p7s (3K) Download Attachment |
Hello all,
However, i find it a good thing to publish regularly the url from www.myofbiz.com . The documentation of ofbiz is a really difficult one to find exactly what you need. And at this url you immediately know where to find the information. Regards, Heidi 2010/4/30 Scott Gray <[hidden email]> > Hi Ruth, > > This is bordering on spam and starting to get annoying, would you mind > trying to contribute to the discussion before starting in with the > advertising? > > Thanks > Scott > > On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: > > > Hello List: > > If anyone is interested in a more in-depth treatment of the Catalog > Manager, products, catalogs and categories, please see my book: "Getting > Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of > this at: http://www.myofbiz.com > > > > Regards, > > Ruth > > ---------------------------------------------------- > > Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" > > [hidden email] > > > > Paul Abernathy wrote: > >> BJ, > >> > >> I also am new to ofbiz and am trying to learn how to use it. I couldn't > help noticing this discussion because I wanted to do the same thing - set up > a hierarchy of categories for products. I was just going through the > business setup guide located at > https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories. I have a couple > of questions: > >> > >> -Can a category be used in more than one Catalog? > >> -Can a category have more than one parent? It looks like the answer is > "no" but just making sure. > >> > >> thanks, > >> > >> Paul > >> > >> BJ Freeman wrote: > >>> 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 > >>> < > 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 < > >>>> [hidden email]> napisa³: > >>>> > >>>> > >>>>> For instanc > >>>>> > >>> > >>> > >>> > >> > >> > > |
In reply to this post by Scott Gray-2
Hi Scott:
How so? I have useful information concerning how OFBiz works and I want to share that with all interested parties. Are you now the OFBiz information censor? Regards, Ruth ---------------------------------------------------- Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" [hidden email] Scott Gray wrote: > Hi Ruth, > > This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising? > > Thanks > Scott > > On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: > > >> Hello List: >> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com >> >> Regards, >> Ruth >> ---------------------------------------------------- >> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >> [hidden email] >> >> Paul Abernathy wrote: >> >>> BJ, >>> >>> I also am new to ofbiz and am trying to learn how to use it. I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products. I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories. I have a couple of questions: >>> >>> -Can a category be used in more than one Catalog? >>> -Can a category have more than one parent? It looks like the answer is "no" but just making sure. >>> >>> thanks, >>> >>> Paul >>> >>> BJ Freeman wrote: >>> >>>> 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 >>>> <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 < >>>>> [hidden email]> napisa³: >>>>> >>>>> >>>>> >>>>>> For instanc >>>>>> >>>>>> >>>> >>>> >>> > > |
In reply to this post by Heidi Dehaes - Olagos
Thank you Heidi.
FYI, unlike the HotWax sponsored blogs and tutorials, there is nothing on my site that advertises anything but how to get more information about OFBiz. Regards, Ruth ---------------------------------------------------- Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" [hidden email] Info Olagos wrote: > Hello all, > > However, i find it a good thing to publish regularly the url from > www.myofbiz.com . > > The documentation of ofbiz is a really difficult one to find exactly what > you need. > > And at this url you immediately know where to find the information. > > Regards, > Heidi > > 2010/4/30 Scott Gray <[hidden email]> > > >> Hi Ruth, >> >> This is bordering on spam and starting to get annoying, would you mind >> trying to contribute to the discussion before starting in with the >> advertising? >> >> Thanks >> Scott >> >> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: >> >> >>> Hello List: >>> If anyone is interested in a more in-depth treatment of the Catalog >>> >> Manager, products, catalogs and categories, please see my book: "Getting >> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of >> this at: http://www.myofbiz.com >> >>> Regards, >>> Ruth >>> ---------------------------------------------------- >>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >>> [hidden email] >>> >>> Paul Abernathy wrote: >>> >>>> BJ, >>>> >>>> I also am new to ofbiz and am trying to learn how to use it. I couldn't >>>> >> help noticing this discussion because I wanted to do the same thing - set up >> a hierarchy of categories for products. I was just going through the >> business setup guide located at >> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories. I have a couple >> of questions: >> >>>> -Can a category be used in more than one Catalog? >>>> -Can a category have more than one parent? It looks like the answer is >>>> >> "no" but just making sure. >> >>>> thanks, >>>> >>>> Paul >>>> >>>> BJ Freeman wrote: >>>> >>>>> 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 >>>>> < >>>>> >> 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 < >>>>>> [hidden email]> napisa³: >>>>>> >>>>>> >>>>>> >>>>>>> For instanc >>>>>>> >>>>>>> >>>>> >>>>> >>>> >> > > |
It's 1am here and I'm not working, I'm contributing to OFBiz and my request had nothing to do with my employer.
Let's not forget that the material you're advertising isn't free. I don't have a problem with advertising but this is a discussion forum and I don't believe that your advertising emails do anything to further the discussion. How about saying something useful and then including your one liner? Regards Scott On 1/05/2010, at 12:56 AM, Ruth Hoffman wrote: > Thank you Heidi. > FYI, unlike the HotWax sponsored blogs and tutorials, there is nothing on my site that advertises anything but how to get more information about OFBiz. > Regards, > Ruth > ---------------------------------------------------- > Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" > [hidden email] > > Info Olagos wrote: >> Hello all, >> >> However, i find it a good thing to publish regularly the url from >> www.myofbiz.com . >> >> The documentation of ofbiz is a really difficult one to find exactly what >> you need. >> >> And at this url you immediately know where to find the information. >> >> Regards, >> Heidi >> >> 2010/4/30 Scott Gray <[hidden email]> >> >> >>> Hi Ruth, >>> >>> This is bordering on spam and starting to get annoying, would you mind >>> trying to contribute to the discussion before starting in with the >>> advertising? >>> >>> Thanks >>> Scott >>> >>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: >>> >>> >>>> Hello List: >>>> If anyone is interested in a more in-depth treatment of the Catalog >>>> >>> Manager, products, catalogs and categories, please see my book: "Getting >>> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of >>> this at: http://www.myofbiz.com >>> >>>> Regards, >>>> Ruth >>>> ---------------------------------------------------- >>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >>>> [hidden email] >>>> >>>> Paul Abernathy wrote: >>>> >>>>> BJ, >>>>> >>>>> I also am new to ofbiz and am trying to learn how to use it. I couldn't >>>>> >>> help noticing this discussion because I wanted to do the same thing - set up >>> a hierarchy of categories for products. I was just going through the >>> business setup guide located at >>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories. I have a couple >>> of questions: >>> >>>>> -Can a category be used in more than one Catalog? >>>>> -Can a category have more than one parent? It looks like the answer is >>>>> >>> "no" but just making sure. >>> >>>>> thanks, >>>>> >>>>> Paul >>>>> >>>>> BJ Freeman wrote: >>>>> >>>>>> 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 >>>>>> < >>>>>> >>> 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 < >>>>>>> [hidden email]> napisa³: >>>>>>> >>>>>>> >>>>>>> >>>>>>>> For instanc >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>> >>> >> >> smime.p7s (3K) Download Attachment |
In reply to this post by Ruth Hoffman-2
On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
> Hi Scott: > How so? How so what? > I have useful information concerning how OFBiz works and I want to share that with all interested parties. Every time you send this out, over 500 people have to deal with an email that contains no information other than a link to a paid product. Hardly in keeping with the spirit of an open source mailing list. Like I said, share some knowledge and then advertise, that way everybody benefits. > Are you now the OFBiz information censor? Hardly, I'm just a fellow user of this mailing list voicing my concern. > Regards, > Ruth > ---------------------------------------------------- > Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" > [hidden email] > > Scott Gray wrote: >> Hi Ruth, >> >> This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising? >> >> Thanks >> Scott >> >> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: >> >> >>> Hello List: >>> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com >>> >>> Regards, >>> Ruth >>> ---------------------------------------------------- >>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >>> [hidden email] >>> >>> Paul Abernathy wrote: >>> >>>> BJ, >>>> >>>> I also am new to ofbiz and am trying to learn how to use it. I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products. I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories. I have a couple of questions: >>>> >>>> -Can a category be used in more than one Catalog? >>>> -Can a category have more than one parent? It looks like the answer is "no" but just making sure. >>>> >>>> thanks, >>>> >>>> Paul >>>> >>>> BJ Freeman wrote: >>>> >>>>> 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 >>>>> <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 < >>>>>> [hidden email]> napisa³: >>>>>> >>>>>> >>>>>>> For instanc >>>>>>> >>>>> >>>> >> >> smime.p7s (3K) Download Attachment |
In reply to this post by Scott Gray-2
Scott:
First, this mailing list is not about you posting your "beliefs" as regards OFBiz or anything else. This mailing list is suppose to be for the dissemination of facts concerning OFBIz. Second, What does charging a minimal fee have to do with this discussion? Third, and most importantly, I am contributing to OFBiz. I just don't have an employer such as HotWax paying my way. That is why I have to charge for these materials. I need to recoup the very real costs of items (such as server hosting) other than my time. Regards, Ruth ---------------------------------------------------- Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" [hidden email] Scott Gray wrote: > It's 1am here and I'm not working, I'm contributing to OFBiz and my request had nothing to do with my employer. > > Let's not forget that the material you're advertising isn't free. > > I don't have a problem with advertising but this is a discussion forum and I don't believe that your advertising emails do anything to further the discussion. How about saying something useful and then including your one liner? > > Regards > Scott > > On 1/05/2010, at 12:56 AM, Ruth Hoffman wrote: > > >> Thank you Heidi. >> FYI, unlike the HotWax sponsored blogs and tutorials, there is nothing on my site that advertises anything but how to get more information about OFBiz. >> Regards, >> Ruth >> ---------------------------------------------------- >> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >> [hidden email] >> >> Info Olagos wrote: >> >>> Hello all, >>> >>> However, i find it a good thing to publish regularly the url from >>> www.myofbiz.com . >>> >>> The documentation of ofbiz is a really difficult one to find exactly what >>> you need. >>> >>> And at this url you immediately know where to find the information. >>> >>> Regards, >>> Heidi >>> >>> 2010/4/30 Scott Gray <[hidden email]> >>> >>> >>> >>>> Hi Ruth, >>>> >>>> This is bordering on spam and starting to get annoying, would you mind >>>> trying to contribute to the discussion before starting in with the >>>> advertising? >>>> >>>> Thanks >>>> Scott >>>> >>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: >>>> >>>> >>>> >>>>> Hello List: >>>>> If anyone is interested in a more in-depth treatment of the Catalog >>>>> >>>>> >>>> Manager, products, catalogs and categories, please see my book: "Getting >>>> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of >>>> this at: http://www.myofbiz.com >>>> >>>> >>>>> Regards, >>>>> Ruth >>>>> ---------------------------------------------------- >>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >>>>> [hidden email] >>>>> >>>>> Paul Abernathy wrote: >>>>> >>>>> >>>>>> BJ, >>>>>> >>>>>> I also am new to ofbiz and am trying to learn how to use it. I couldn't >>>>>> >>>>>> >>>> help noticing this discussion because I wanted to do the same thing - set up >>>> a hierarchy of categories for products. I was just going through the >>>> business setup guide located at >>>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories. I have a couple >>>> of questions: >>>> >>>> >>>>>> -Can a category be used in more than one Catalog? >>>>>> -Can a category have more than one parent? It looks like the answer is >>>>>> >>>>>> >>>> "no" but just making sure. >>>> >>>> >>>>>> thanks, >>>>>> >>>>>> Paul >>>>>> >>>>>> BJ Freeman wrote: >>>>>> >>>>>> >>>>>>> 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 >>>>>>> < >>>>>>> >>>>>>> >>>> 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 < >>>>>>>> [hidden email]> napisa³: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> For instanc >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>> >>>> >>> >>> > > |
In reply to this post by Scott Gray-2
Scott Gray wrote: > On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote: > > >> Hi Scott: >> How so? >> > > How so what? > > >> I have useful information concerning how OFBiz works and I want to share that with all interested parties. >> > > Every time you send this out, over 500 people have to deal with an email that contains no information other than a link to a paid product. Hardly in keeping with the spirit of an open source mailing list. Like I said, share some knowledge and then advertise, that way everybody benefits. > > >> Are you now the OFBiz information censor? >> > > Hardly, I'm just a fellow user of this mailing list voicing my concern. > > >> Regards, >> Ruth >> ---------------------------------------------------- >> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >> [hidden email] >> >> Scott Gray wrote: >> >>> Hi Ruth, >>> >>> This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising? >>> >>> Thanks >>> Scott >>> >>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote: >>> >>> >>> >>>> Hello List: >>>> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com >>>> >>>> Regards, >>>> Ruth >>>> ---------------------------------------------------- >>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz" >>>> [hidden email] >>>> >>>> Paul Abernathy wrote: >>>> >>>> >>>>> BJ, >>>>> >>>>> I also am new to ofbiz and am trying to learn how to use it. I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products. I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories. I have a couple of questions: >>>>> >>>>> -Can a category be used in more than one Catalog? >>>>> -Can a category have more than one parent? It looks like the answer is "no" but just making sure. >>>>> >>>>> thanks, >>>>> >>>>> Paul >>>>> >>>>> BJ Freeman wrote: >>>>> >>>>> >>>>>> 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 >>>>>> <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 < >>>>>>> [hidden email]> napisa³: >>>>>>> >>>>>>> >>>>>>> >>>>>>>> For instanc >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>> >>> > > |
Free forum by Nabble | Edit this page |