Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002077 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] B. User interface | minor | always | 2007-10-11 10:08 | 2008-07-02 17:31 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 2261 | ||||
| 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 | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002077: 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 | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0002345) dbaz (viewer) 2007-11-30 19:38 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1500873 Originator: NO Thanks eintel! When I solve my 2.3x critical bugs I will test it in order to include it on the 2.40! Thanks again! |
|
(0002346) villind (viewer) 2008-01-24 10:49 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=61737 Originator: NO Hi, I tried to apply this to the trunk and xsql file was successful, but java file failed. If you have time to bring this patch up to date with current trunk I can try to apply it to performance branch. Ville |
|
(0002347) user71 2008-01-24 11:17 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1737231 Originator: YES Ville, I'm off for a long weekend but I will update the patch next week Ben |
|
(0002348) dbaz (viewer) 2008-01-24 11:32 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1500873 Originator: NO One thing: "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)." Now, in 2.35MP1 the grid has been improved and always shows data. The lack of data in some grids with a lot of data was due to a failure in the ExecuteQuery.java. This class request all the data instead of request only the required data. It have been fixed as I said. Thanks again. |
|
(0002349) alostale (viewer) 2008-02-06 10:52 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1500722 Originator: NO I have applied the patch (trunk rev. 2261), but only the part affecting TableSQLQuery_data.xsql and TableSQL.java. Because I want to review KeyMap class more deeply. Thank you very much for your contribution. |
|
(0005666) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1811346 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-06-24 17:03 | cromero | Status | closed => new |
| 2008-06-24 17:03 | cromero | Resolution | fixed => open |
| 2008-06-24 17:03 | cromero | Fixed in Version | 2.40alpha-r2 => |
| 2008-06-24 17:04 | cromero | Status | new => scheduled |
| 2008-06-24 17:04 | cromero | Status | scheduled => resolved |
| 2008-06-24 17:04 | cromero | svn_revision | => 2261 |
| 2008-06-24 17:04 | cromero | Resolution | open => fixed |
| 2008-06-24 17:56 | cromero | Status | resolved => new |
| 2008-06-24 17:56 | cromero | Resolution | fixed => open |
| 2008-06-24 17:56 | cromero | Status | new => scheduled |
| 2008-06-24 17:57 | cromero | Status | scheduled => resolved |
| 2008-06-24 17:57 | cromero | Fixed in Version | => 2.40alpha-r2 |
| 2008-06-24 17:57 | cromero | Resolution | open => fixed |
| 2008-07-02 17:31 | plujan | Status | resolved => closed |
| 2008-07-02 17:31 | plujan | Fixed in Version | 2.40alpha-r2 => 2.40beta |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |