Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000497 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2008-05-30 16:59 | 2008-07-01 17:56 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40alpha-r3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 4702 | ||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 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 | 0000497: Grid query optimization | |||||||
| Description | The query to obtain data for the grid (TableSQLData class) can be modified in order to gain some performance specially for tabs with a huge number of records. Currently a number (depending on the tab) of left joins are evaluated for all the records before the application of the range delimiter. This delimiter can be applied before making only necessary to execute for all the records the left joins that affect to the fields in the order by clause. This bug is related with this issue: https://sourceforge.net/tracker/index.php?func=detail&aid=1863256&group_id=162271&atid=823129 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0000393) svnbot (reporter) 2008-05-30 17:01 |
Repository: openbravo Revision: 4702 Author: alostale Date: 2008-05-30 17:01:31 +0200 (Fri, 30 May 2008) fixed issue 0000497: Datagrid performance for huge tables has been improved --- _U trunk/ U trunk/src/org/openbravo/erpCommon/utility/DataGrid.java U trunk/src/org/openbravo/erpCommon/utility/ExecuteQuery.java U trunk/src/org/openbravo/erpCommon/utility/ExportGrid.java U trunk/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java U trunk/src/org/openbravo/erpCommon/utility/QueryFieldStructure.java U trunk/src/org/openbravo/erpCommon/utility/QueryParameterStructure.java U trunk/src/org/openbravo/erpCommon/utility/TableSQLData.java U trunk/src-wad/src/org/openbravo/wad/javasource.javaxml --- https://dev.openbravo.com/websvn/openbravo/?rev=4702&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-30 16:59 | alostale | New Issue | |
| 2008-05-30 16:59 | alostale | Assigned To | => cromero |
| 2008-05-30 17:00 | alostale | Status | new => scheduled |
| 2008-05-30 17:00 | alostale | Assigned To | cromero => alostale |
| 2008-05-30 17:01 | svnbot | Checkin | |
| 2008-05-30 17:01 | svnbot | Note Added: 0000393 | |
| 2008-05-30 17:01 | svnbot | Status | scheduled => resolved |
| 2008-05-30 17:01 | svnbot | Resolution | open => fixed |
| 2008-05-30 17:01 | svnbot | svn_revision | => 4702 |
| 2008-06-11 12:46 | cromero | Target Version | => 2.40 |
| 2008-06-11 14:33 | cromero | Fixed in Version | => 2.40alpha r3 |
| 2008-06-19 14:01 | plujan | Status | resolved => closed |
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007913 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |