Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010968 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-10-14 17:31 | 2009-10-17 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.40MP3 | 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 | 0010968: Time response of query generated by WAD is very high | |||||||
| Description | In sales order window, in tab lines, the query generated by WAD to edit a record (selectEdit) is very slow when exists a lot of orders. | |||||||
| Steps To Reproduce | enviroment with 20.000 orders and 200.000 order lines. Sales Management || Transactions || Sales Order || Header >> Lines -> edit record if you push "Go forward one record" button, the time to response is higher than 5 seconds | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0021009) networkb (developer) 2009-10-14 17:33 |
we have sent to Stefan an enviroment with this problem. |
|
(0021010) shuehner (administrator) 2009-10-14 17:35 |
Some first testing it seems that issue is missing to_number call around the _ID fields in wad-generated xsql files used for the selectEdit method of generated window. Additionally need to verify performance problem on latest MP9 |
|
(0021011) networkb (developer) 2009-10-14 17:37 |
It is related to ticket 6049 in support portal |
|
(0021066) psarobe (manager) 2009-10-15 16:33 |
Hi Stefan, If you think that the performance is good enough in MP9 or latest please reject the bug saying that it's fixed in MP9 or later |
|
(0021116) shuehner (administrator) 2009-10-16 15:23 |
The issue only exists on 2.40 with postgres. Rejecting the defect as not changes is required on pi. The 2.40 issue is tracked as backport 10989. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-14 17:31 | networkb | New Issue | |
| 2009-10-14 17:31 | networkb | Assigned To | => rafaroda |
| 2009-10-14 17:33 | networkb | Note Added: 0021009 | |
| 2009-10-14 17:35 | shuehner | Note Added: 0021010 | |
| 2009-10-14 17:37 | networkb | Note Added: 0021011 | |
| 2009-10-15 16:31 | psarobe | Priority | immediate => high |
| 2009-10-15 16:33 | psarobe | Status | new => scheduled |
| 2009-10-15 16:33 | psarobe | Note Added: 0021066 | |
| 2009-10-15 16:33 | psarobe | Assigned To | rafaroda => shuehner |
| 2009-10-15 16:33 | psarobe | fix_in_branch | => pi |
| 2009-10-16 15:23 | shuehner | Status | scheduled => closed |
| 2009-10-16 15:23 | shuehner | Note Added: 0021116 | |
| 2009-10-16 15:23 | shuehner | Resolution | open => no change required |
| 2009-10-17 00:00 | anonymous | sf_bug_id | 0 => 2880781 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |