[ https://issues.apache.org/jira/browse/OFBIZ-628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465304 ]
eric schwartz commented on OFBIZ-628: ------------------------------------- the above info is not correct. we removed the if statement because the way the code worked was that it would do a lookup of all items in product category and if the lookup returned results it would show the content in the ftl file. when we removed the lookup (which was what was slowing down the page) the content was no longer displayed. i am not sure why this if statement was even neccessary. you wouldnt be able to navigate to this page unless you had product categories and even if you do get to the page and no product categories exist it would not let you do anything. for example if you pass it a bogus category it will tell you it cannot do the desired operation because the category does not exist. this if statement should have probably been removed regardless of our removing the lookup or not. > Change ProductCategory dropdowns to lookup windows > -------------------------------------------------- > > Key: OFBIZ-628 > URL: https://issues.apache.org/jira/browse/OFBIZ-628 > Project: Apache OFBiz (The Open for Business Project) > Issue Type: Improvement > Components: product > Affects Versions: SVN trunk > Environment: All > Reporter: Walter Vaughan > Assigned To: Si Chen > Fix For: SVN trunk > > Attachments: patch_category_lookup, patch_category_lookup2 > > > There are several places in ofBiz where a drop down window is used to select > a ProductCategory. However, in installations with a significant number of > categories, the overhead of a sequential scan query causes severe slowdowns > in the performance of ofBiz, and overloads the browser client. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira