Hi Ian,I didn't say OFBiz wasn't intended to handle this sort of load, I just said that the purchase order code may not have been optimized for it. I have no doubt that OFBiz can handle what you're describing but you may find portions of the code could be improved to speed things up a bit, like using the cache where appropriate, using the entity iterator rather than retrieving full lists for large result sets, improving queries to make better use of indexes, etc. After that it really just comes down to your hardware.
Regards Scott On 11/11/2009, at 8:26 PM, ian tabangay wrote:
Hi Scott,No its not the customers who are ordering. These are purchase orders of the500 facilities (or stores). I think its mostly the sheer number ofinserts/updates that is required to complete the process. I did a similarapplication that inserts/updates to the same entities directly to thedatabase to complete a purchase order and the results, as compared to how ofbiz does, it wasn't significantly faster. Right now Im finding ways to divide the work and/or remove this load from the main ofbiz server to giveway for other processes that will be maintained by ofbiz.What I wanted to try is to implement ofbiz as a tool to manage inventories and sales of multiple stores; about 500 stores selling about 18,000 products doing at least 1 sales transaction (average of 4 line items) per minute. Stores make purchase orders everyday for about 800 products each day. You mentioned that ofbiz wasnt intended for this kind of use? What would you saycould be managable by ofbiz OOTB (or with minor changes)? --- Ian TabangayOn Wed, Nov 11, 2009 at 12:39 PM, Scott Gray <[email protected] >wrote:Hi IanMy guess is that because most people don't order 1000 different products in a single purchase order the code has never been optimized to deal with that scenario. The framework itself can certainly handle it so it's really just a matter of finding the bottlenecks and improving the offending code. If you can locate the portions of code that are slowing things down it will beeasier to offer suggestions on how to improve it. Regards Scott HotWax Media http://www.hotwaxmedia.com
smime.p7s
Description: S/MIME cryptographic signature
