Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000497Openbravo ERPA. Platformpublic2008-05-30 16:592008-07-01 17:56
alostale 
alostale 
normalminorhave not tried
closedfixed 
5
 
2.402.40alpha-r3 
Core
No
0000497: Grid query optimization
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 [^]
No tags attached.
Issue History
2008-05-30 16:59alostaleNew Issue
2008-05-30 16:59alostaleAssigned To => cromero
2008-05-30 17:00alostaleStatusnew => scheduled
2008-05-30 17:00alostaleAssigned Tocromero => alostale
2008-05-30 17:01svnbotCheckin
2008-05-30 17:01svnbotNote Added: 0000393
2008-05-30 17:01svnbotStatusscheduled => resolved
2008-05-30 17:01svnbotResolutionopen => fixed
2008-05-30 17:01svnbotsvn_revision => 4702
2008-06-11 12:46cromeroTarget Version => 2.40
2008-06-11 14:33cromeroFixed in Version => 2.40alpha r3
2008-06-19 14:01plujanStatusresolved => closed
2008-07-01 17:56anonymoussf_bug_id0 => 2007913

Notes
(0000393)
svnbot   
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 [^]