Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004964 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] I. Performance | minor | sometimes | 2008-09-09 17:26 | 2009-11-03 06:59 | |||
| Reporter | jaimetorre | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | 2.40MP11 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 0b7c8b69af9c | |||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | 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 | 0004964: Slow compilation in sqlC part due to high amount of data | |||||||
| Description | When compiling, sqlC executes each query to verify the sql syntax. However, if the select returns a big amount of data, sqlC takes very long to respond. sqlC execution time should not depend on the amount of data in the database. Data is not even needed to check the correction of the sql. In order to avoid this issue, an impossilbe condition (e.g., 1=2) should be added to the sql query before testing it. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0020966) shuehner (administrator) 2009-10-13 10:23 |
Push of fix pending. Waiting for 2.40 branch to be unfrozen |
|
(0021050) hgbot (developer) 2009-10-15 13:22 |
Repository: erp/stable/2.40 Changeset: 0b7c8b69af9c12841ff4c7263f4fff26c6e41fb1 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Oct 13 10:22:07 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/0b7c8b69af9c12841ff4c7263f4fff26c6e41fb1 [^] Fixed 4964: Improve SqlC performance at compile time (for big datasets) - Include optional parameters in SqlC query execution at compile time as this leads to better performance in many cases - This requires the optional parameters to be valid parts of an SQL statement - New behavior can be configured via new Openbravo.properties setting: sqlc.queryExecutionStrategy=traditional,optimized - Enable traditional by default (in template and when new setting is missing) - Can be enabled manually to get better compile time performance if in custom code all optional parameters are valid sql. --- M config/Openbravo.properties.template M src-core/src/org/openbravo/data/Sqlc.java M src/buildAD.xml --- |
|
(0021521) arunkumar (viewer) 2009-11-03 06:59 |
Tested & Working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-09 17:26 | anonymous | New Issue | |
| 2008-09-09 17:26 | anonymous | Assigned To | => marvintm |
| 2008-09-09 17:26 | anonymous | Status | new => scheduled |
| 2008-09-09 17:26 | anonymous | fix_in_branch | => 2.40 |
| 2008-11-05 12:02 | cromero | OBNetwork customer | => No |
| 2008-11-05 12:02 | cromero | Priority | normal => low |
| 2008-11-05 12:02 | cromero | Category | A. Platform (WAD, XmlEngine, SQLC) => I. Performance |
| 2009-01-09 15:20 | rafaroda | Assigned To | marvintm => shuehner |
| 2009-01-19 10:31 | rafaroda | version | => 2.40 |
| 2009-08-02 19:42 | psarobe | Status | scheduled => closed |
| 2009-08-02 19:42 | psarobe | Resolution | open => suspended |
| 2009-10-13 10:14 | shuehner | Status | closed => new |
| 2009-10-13 10:14 | shuehner | Resolution | suspended => open |
| 2009-10-13 10:14 | shuehner | Status | new => scheduled |
| 2009-10-13 10:14 | shuehner | fix_in_branch | 2.40 => pi |
| 2009-10-13 10:15 | shuehner | fix_in_branch | pi => 2.40 |
| 2009-10-13 10:23 | shuehner | Note Added: 0020966 | |
| 2009-10-15 13:22 | hgbot | Checkin | |
| 2009-10-15 13:22 | hgbot | Note Added: 0021050 | |
| 2009-10-15 13:22 | hgbot | Status | scheduled => resolved |
| 2009-10-15 13:22 | hgbot | Resolution | open => fixed |
| 2009-10-15 13:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/0b7c8b69af9c12841ff4c7263f4fff26c6e41fb1 [^] |
| 2009-10-22 19:26 | psarobe | Tag Attached: main | |
| 2009-10-29 09:47 | psarobe | Tag Detached: main | |
| 2009-10-29 09:48 | psarobe | Target Version | => 2.40MP11 |
| 2009-11-03 06:59 | arunkumar | Status | resolved => closed |
| 2009-11-03 06:59 | arunkumar | Note Added: 0021521 | |
| 2009-11-03 06:59 | arunkumar | Fixed in Version | => 2.40MP11 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |