Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004799 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] I. Performance | major | always | 2008-09-03 13:54 | 2008-10-08 22:42 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.35MP9 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | 7336 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004799: It takes too much time to show all the products when you have many products | |||||||
| Description | When accessing to the Products catalog window in relation mode, it takes too much time (around 10 seconds) to show the results. Moreover, sometimes the results are not even shown and the user has to launch an additional product search in order to obtain some results. The window works fine in edition mode, but it has an unacceptable behavior when switching to relation mode. In terms of volume, the complete customer's products catalog has 200.000 different products. We are having this problem with only 130.000 products and we are afraid that the problem will be worse with the complete catalog. Hardware: # 4 CPU(s): 4 x CPU model: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz. Frequency: 1995.082 # Total memory: 4048 MB # Memory free: 1397 MB # Total swap: 1992 MB # Swap free: 1992 MB | |||||||
| Proposed Solution | A possible is limiting the amount of products that are loaded in the relation mode (for example, 1.000) and only load the next block of products when navigating to the 1.001 or further products. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008998) svnbot (reporter) 2008-09-11 12:48 |
Repository: openbravo Revision: 7195 Author: iperdomo Date: 2008-09-11 12:48:47 +0200 (Thu, 11 Sep 2008) Fixes issue 4799. Backported changes to improve performance on the grid. --- U branches/r2.3x/src/org/openbravo/erpCommon/utility/DataGrid.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExecuteQuery.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExportGrid.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/QueryFieldStructure.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/QueryParameterStructure.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/TableSQLData.java U branches/r2.3x/src-wad/src/org/openbravo/wad/javasource.javaxml --- https://dev.openbravo.com/websvn/openbravo/?rev=7195&sc=1 [^] |
|
(0009023) svnbot (reporter) 2008-09-16 08:56 |
Repository: openbravo Revision: 7336 Author: iperdomo Date: 2008-09-16 08:56:23 +0200 (Tue, 16 Sep 2008) Fixes export grid. Related to issue 4799 --- U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExportGrid.java --- https://dev.openbravo.com/websvn/openbravo/?rev=7336&sc=1 [^] |
|
(0009472) psarobe (manager) 2008-10-08 22:42 |
Tested by consulting in a real environment |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-03 13:54 | cromero | New Issue | |
| 2008-09-03 13:54 | cromero | Assigned To | => iperdomo |
| 2008-09-03 13:54 | cromero | Status | new => scheduled |
| 2008-09-11 12:48 | svnbot | Checkin | |
| 2008-09-11 12:48 | svnbot | Note Added: 0008998 | |
| 2008-09-11 12:48 | svnbot | Status | scheduled => resolved |
| 2008-09-11 12:48 | svnbot | Resolution | open => fixed |
| 2008-09-11 12:48 | svnbot | svn_revision | => 7195 |
| 2008-09-16 08:56 | svnbot | Checkin | |
| 2008-09-16 08:56 | svnbot | Note Added: 0009023 | |
| 2008-09-16 08:56 | svnbot | svn_revision | 7195 => 7336 |
| 2008-10-08 22:42 | psarobe | Regression testing | => No |
| 2008-10-08 22:42 | psarobe | Status | resolved => closed |
| 2008-10-08 22:42 | psarobe | Note Added: 0009472 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |