Hello, Thank you for your quick response. Regarding your question about real world applications: Ecommerce: http://www.rockauto.com/ http://allegro.pl/
There are applications that holds > 1 000 000 categories. In a PLM industry it's also very common to have a couple of milions of objects (consider the complexity of a train or a plain for example). The point of my post was not a fix, but the implementation of the find root category method. I think that you should avoid such a code. You have got great database layer (great possibility to improve performance) so it would be great to utilize it as much as it's possible. I really like Ofbiz application thats why I try to give you my input. Once again thank you for the response and for the link you send me. I will come back with the better solution after studing the datamodel. Regards, Michał Cukierman W dniu 30 kwietnia 2010 10:11 użytkownik Jacques Le Roux < [email protected]> napisał: > For instanc
