From: "Len Shein" <[email protected]> >I am using Ofbiz 10.04. > > I have on my DB 3000 Product price rules (entity PRODUCT_PRICE_RULE) and > 6000 Product Price Conditions (entity PRODUCT_PRIE_COND). All of my price > conditions are setup for Quantity Breaks in pricing. > > When calling the 'caclulateProductPrice' service for a single product; the > service reads 'all' of the Product Price Rules (using cache) and 'all' of > the product price conditions for each price rule. Two lists are then built > of 'quantity product Prices Rules' and 'non quantity product price rules'. > The 'quantity product price rules' list is now interrogated to determine if > any price conditions are 'true' by calling method 'checkPriceCondition'. > > > > In my scenario over '3000' DB hits would have been made and processing of > 6000 rows is performed to determine if a 'single' product has price rules. > > > > Has anyone come across any performance issues since calculateProductPrice > service may be called from multiple areas of an eCommerce Site (list page > and detail page)?
I remember the Neogia project did something about that. It's at least used in the OYA ERP http://www.c-libre.net/web/guest/oya which is Neogia based. I can't say more since I did not participate to the development. > Has any work been done in later versions of Ofbiz (11.04) to optimize this? Nope > Would it make more sense to first see if Product Price Condition is 'true' > before reading the associated Product Price Rule is active? Maybe :) Jacques > > > > > Thank You > > > > Len Shein > > > > [email protected] > > [email protected] > > > > 516.742.7888 ext.225 > > 732.333.4303 > > > >
