[jira] [Commented] (OFBIZ-3856) quicker picklist option functionality

["Pierre Smits (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-3856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17466121#comment-17466121 ] 

Pierre Smits commented on OFBIZ-3856:
-------------------------------------

Is this still an issue (that we want/need to pursue)|?

> quicker picklist option functionality
> -------------------------------------
>
>                 Key: OFBIZ-3856
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3856
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: product
>    Affects Versions: Release 4.0, Release 09.04, Trunk
>            Reporter: Albert Mayo
>            Priority: Minor
>         Attachments: FindOrdersToPick.groovy, PickListServices.java, entitymodel.xml, quicker picklist.diff
>
>
> 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.
> For instance, the picklistoptions function does the following (abbreviated):
> select * from OrderHeader
> for each orderHeader {
>     select * from OrderItemShipGroup where orderId = orderHeader.orderId
>     for each orderItemShipGroup in orderItemShipGroupList {
>         select * from OrderItemShipGrpInvRes where orderId = orderItemShipGroup.orderId;
>         for each orderItemShipGrpInvRes in orderItemShipGrpInvResList {
>             etc....
>          }
>     }
> }
> These kind of loops can create many hits to the database and greatly slow down the process, especially if the database tables have many records.  Our database is now almost 8 gigs.  The PicklistOptions process took ~4 minutes for 40 pickable orders. 
> I am using OFBiz 4.0, but the trunk version has a lot of the same code.  I am opening this ticket to start a conversation of a quicker method to create picklists, like with the use of views or DynamicViewEntitys. 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)