Question regarding Catalog management in Ofbiz

[Michal Cukierman]

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

[Jacques Le Roux]

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

[Michal 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

[BJ Freeman]

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 <
> [hidden email]> napisał:
>
>> For instanc
>

[Michal Cukierman]

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
> 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 <
> > [hidden email]> napisał:
> >
> >> For instanc
> >
>
>
>

[Michal Cukierman]

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
>> 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 <
>> > [hidden email]> napisał:
>> >
>> >> For instanc
>> >
>>
>>
>>
>

[BJ Freeman]

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
Linkedin
<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
>

[BJ Freeman]

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
> <[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
>>> 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 <
>>>> [hidden email]> napisał:
>>>>
>>>>> For instanc
>>>
>>>
>

[Paul Abernathy]

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 <
>> [hidden email]> napisał:
>>
>>    
>>> For instanc
>>>      
>
>
>  

[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
Linkedin
<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
>> 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 <
>>> [hidden email]> napisał:
>>>
>>>    
>>>> For instanc
>>>>      
>>
>>
>>  
>
>

[Scott Gray-2]

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
>>> 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 <
>>>> [hidden email]> napisał:
>>>>
>>>>> For instanc
>>>>
>>>
>>>
>>>
>>

[Ruth Hoffman-2]

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
>> 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 <
>>> [hidden email]> napisa³:
>>>
>>>    
>>>> For instanc
>>>>      
>>
>>
>>  
>
>

[Scott Gray-2]

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
>>> 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 <
>>>> [hidden email]> napisa³:
>>>>
>>>>  
>>>>> For instanc
>>>>>      
>>>
>>>
>>>  
>>
>>

[Heidi Dehaes - Olagos]

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
> >>> 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 <
> >>>> [hidden email]> napisa³:
> >>>>
> >>>>
> >>>>> For instanc
> >>>>>
> >>>
> >>>
> >>>
> >>
> >>
>
>

[Ruth Hoffman-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
>>>> 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 <
>>>>> [hidden email]> napisa³:
>>>>>
>>>>>  
>>>>>          
>>>>>> For instanc
>>>>>>      
>>>>>>            
>>>>  
>>>>        
>>>      
>
>  

[Ruth Hoffman-2]

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
>>>>> 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 <
>>>>>> [hidden email]> napisa³:
>>>>>>
>>>>>>
>>>>>>            
>>>>>>> For instanc
>>>>>>>
>>>>>>>              
>>>>>
>>>>>          
>>>>        
>>    
>
>  

[Scott Gray-2]

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
>>>>>> 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 <
>>>>>>> [hidden email]> napisa³:
>>>>>>>
>>>>>>>
>>>>>>>            
>>>>>>>> For instanc
>>>>>>>>
>>>>>>>>              
>>>>>>
>>>>>>          
>>>>>        
>>>    
>>
>>  

[Scott Gray-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
>>>>> 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 <
>>>>>> [hidden email]> napisa³:
>>>>>>
>>>>>>            
>>>>>>> For instanc
>>>>>>>                
>>>>>        
>>>>      
>>
>>  

[Ruth Hoffman-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
>>>>>>> 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 <
>>>>>>>> [hidden email]> napisa³:
>>>>>>>>
>>>>>>>>
>>>>>>>>            
>>>>>>>>                
>>>>>>>>> For instanc
>>>>>>>>>
>>>>>>>>>              
>>>>>>>>>                  
>>>>>>>          
>>>>>>>              
>>>>>>        
>>>>>>            
>>>>    
>>>>        
>>>  
>>>      
>
>  

[Ruth Hoffman-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.
>  

Really? 500? Where did you come up with that number?

>  
>> 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
>>>>>> 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 <
>>>>>>> [hidden email]> napisa³:
>>>>>>>
>>>>>>>            
>>>>>>>              
>>>>>>>> For instanc
>>>>>>>>                
>>>>>>>>                
>>>>>>        
>>>>>>            
>>>>>      
>>>>>          
>>>  
>>>      
>
>