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
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 <
jacques.le.r...@les7arts.com> napisał:
For instanc