Has anyone else noticed the amount of time it could take to load the PicklistOptions view for larger batches of orders and a larger database history?
I am noticing as our OFBiz database grows larger, it is taking the PicklistOptions longer to load. Even for a batch as small as 50 orders it can take up to a couple minutes to load. 300 orders can take upwards of 5-10 minutes. My development system with much lesser hardware can get through a hundred orders in seconds, so I have a feeling it has to do with the process/code inefficiency. I am using OFBiz 4.0. Has this already been fixed in the trunk version? If not, I have developed a faster picklist process for my copmany that makes minimal hits to the database and utilizes better prepared SQL statements to get the same result. It may be a nice foundation to a substantially improved picklist process for the trunk version. Would anyone be interested in this code? If so, should I create a Jira ticket and attach the code? -- View this message in context: http://ofbiz.135035.n4.nabble.com/PicklistOptions-processing-time-tp2280129p2280129.html Sent from the OFBiz - Dev mailing list archive at Nabble.com.
