[ https://issues.apache.org/jira/browse/OFBIZ-628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465297 ]
Walter Vaughan commented on OFBIZ-628: -------------------------------------- Removed the debug logging and code that we just commented out in the bean shell. We removed the if statement because it was written such that it did a sequential scan of the entire ProductCatagory file to see if the ProductCategoryId existed. It the used the if statements to determine if it should display items to work with that product category. However, if it failed the "if" it didn't display an error message, it just left a 90% blank page with no reason, so it really wasn't error checking either. Now at least you get a nice short error message from ofBiz that you are working with an invalid ProductCategoryId. > 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