[ 
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

        

Reply via email to