[ 
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

        

Reply via email to