Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004155 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] B. User interface | minor | always | 2008-06-24 17:04 | 2008-10-08 18:41 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | gorka_gil | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.35MP7 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | 5477 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004155: Grid view results in very large number of db queries | |||||||
| Description | OS: Linux - Suse 10.2 (test/prod) & Windows XP (dev) DB: Postgres 8.1.5 (test/prod) & 8.2.4 (dev) Release: 2.34 Browser: Firefox 2.0.0.6, IE 7 Actually noticed this one in an installation on an an old server. When viewing the Purchase Order grid each datagrid ajax request would take about 5 seconds. This often caused the grid not to display the data (I assume due to an ajax timeout). The slowness is caused by the construction of the table sql. In the Purchase order case the structure comes back quickly then when creating the sql it goes off the db again many many times. I was able to improve it significantly by only fetching the displayed columns/fields in the initial structure query. (which then cuts down on the the number of subsequent db requests). After applying the attached patch the request time went down to less than a second. There is still lots of room for optimization but this helps a lot. | |||||||
| Tags | OBN | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008060) svnbot (viewer) 2008-06-30 11:47 |
Repository: openbravo Revision: 5477 Author: gorka_gil Date: 2008-06-30 11:47:53 +0200 (Mon, 30 Jun 2008) fixed bug 4155 Grid view results in very large number of db queries --- U branches/r2.3x/src/org/openbravo/erpCommon/utility/TableSQLData.java U branches/r2.3x/src/org/openbravo/erpCommon/utility/TableSQLQuery_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=5477&sc=1 [^] |
|
(0009458) psarobe (viewer) 2008-10-08 18:41 |
Impossible to test with that information. Talking with GGI, he cannot tell what to test to ensure it is fixed. Just code review |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-06-24 17:04 | cromero | New Issue | |
| 2008-06-24 17:04 | cromero | Assigned To | => alostale |
| 2008-06-24 17:04 | cromero | Status | new => scheduled |
| 2008-06-24 17:04 | cromero | Tag Attached: OBN | |
| 2008-06-24 17:04 | cromero | OBNetwork customer | => Yes |
| 2008-06-24 17:04 | cromero | Priority | normal => urgent |
| 2008-06-24 17:04 | cromero | Description Updated | |
| 2008-06-24 18:04 | cromero | Status | scheduled => feedback |
| 2008-06-27 12:22 | cromero | Status | feedback => scheduled |
| 2008-06-27 12:22 | cromero | Assigned To | alostale => gorka_gil |
| 2008-06-30 11:47 | svnbot | Checkin | |
| 2008-06-30 11:47 | svnbot | Note Added: 0008060 | |
| 2008-06-30 11:47 | svnbot | Status | scheduled => resolved |
| 2008-06-30 11:47 | svnbot | Resolution | open => fixed |
| 2008-06-30 11:47 | svnbot | svn_revision | => 5477 |
| 2008-10-08 18:41 | psarobe | Regression testing | => No |
| 2008-10-08 18:41 | psarobe | Status | resolved => closed |
| 2008-10-08 18:41 | psarobe | Note Added: 0009458 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |