Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0020733 | Openbravo ERP | A. Platform | public | 2012-06-12 12:45 | 2012-06-27 05:29 |
|
| Reporter | mtaal | |
| Assigned To | mtaal | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0MP13 | Fixed in Version | 3.0MP13 | |
| 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 | 0020733: Json serialization: always the identifier properties of associated entities are serialized also, resulting in extra queries |
| Description | When doing json serialization the identifiers of associated objects are also serialized, for this the referenced object is read using a separate query. |
| Steps To Reproduce | Read and json serialize for example a sales order, the business partner is read in a separate query, improve performance by left joining all associations in case of json serialization. |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0020859 | | closed | alostale | Alert management window does not show any information |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-06-12 12:45 | mtaal | New Issue | |
| 2012-06-12 12:45 | mtaal | Assigned To | => mtaal |
| 2012-06-12 12:45 | mtaal | Modules | => Core |
| 2012-06-12 12:45 | mtaal | OBNetwork customer | => No |
| 2012-06-12 15:59 | alostale | Tag Attached: Performance | |
| 2012-06-12 15:59 | alostale | Type | defect => design defect |
| 2012-06-21 12:03 | hgbot | Checkin | |
| 2012-06-21 12:03 | hgbot | Note Added: 0049971 | |
| 2012-06-21 12:03 | hgbot | Status | new => resolved |
| 2012-06-21 12:03 | hgbot | Resolution | open => fixed |
| 2012-06-21 12:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ddef3520f532c1a44e73122526954f13e793c821 [^] |
| 2012-06-21 12:03 | hgbot | Checkin | |
| 2012-06-21 12:03 | hgbot | Note Added: 0049976 | |
| 2012-06-26 15:40 | mtaal | Note Added: 0050093 | |
| 2012-06-26 15:40 | mtaal | Status | resolved => closed |
| 2012-06-26 15:40 | mtaal | Fixed in Version | => 3.0MP13 |
| 2012-06-26 16:09 | alostale | Relationship added | related to 0020859 |
| 2012-06-27 05:28 | hudsonbot | Checkin | |
| 2012-06-27 05:28 | hudsonbot | Note Added: 0050142 | |
| 2012-06-27 05:29 | hudsonbot | Checkin | |
| 2012-06-27 05:29 | hudsonbot | Note Added: 0050146 | |
|
Notes |
|
|
(0049971)
|
|
hgbot
|
|
2012-06-21 12:03
|
|
Repository: erp/devel/pi
Changeset: ddef3520f532c1a44e73122526954f13e793c821
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Jun 13 11:49:16 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ddef3520f532c1a44e73122526954f13e793c821 [^]
Fixes issue 20733: Json serialization: always the identifier properties of associated entities are serialized also, resulting in
Join the associated objects in the query so that the identifier can be read without extra queries
---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataEntityQueryService.java
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java
M src-test/org/openbravo/test/dal/IssuesTest.java
---
|
|
|
|
(0049976)
|
|
hgbot
|
|
2012-06-21 12:03
|
|
Repository: erp/devel/pi
Changeset: e05b39aac3571f79c38cae8b62441863e5561386
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Jun 14 13:33:57 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e05b39aac3571f79c38cae8b62441863e5561386 [^]
Related to issue 20733: Json serialization: always the identifier properties of associated entities are serialized also, resulting in extra queries
Solve alias issue when filtering in grid
---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
|
|
|
|
(0050093)
|
|
mtaal
|
|
2012-06-26 15:40
|
|
|
The functionality is disabled for now as it results in a less performance for queries on large databases |
|
|
|
|
|
|
|
|
|