Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009641 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-06-25 16:36 | 2009-07-23 00:00 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 79d24670c339 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | 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 | 0009641: Navigating to first record in generated windows is too slow with many records. | |||||||
| Description | Example: #products = 1.000.000 Opening the product window in edit mode. Then press ok in the automatically opened search popup. Retrieving the first product (which is shown after pressing OK) takes more than 1.5s for a single user. This is too slow when you try to scale to many users. | |||||||
| Steps To Reproduce | See description. | |||||||
| Tags | 250MP3releasecandidate, leo | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017590) hgbot (developer) 2009-06-25 16:55 |
Repository: erp/devel/pi Changeset: 79d24670c33942d5d80fb61c7d09440e9f6e782d Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Jun 25 16:55:10 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/79d24670c33942d5d80fb61c7d09440e9f6e782d [^] Fixed 9641: Improve performance of generated window navigation - Move rownum on oracle to better location - Embedd limit/offset/rownum parameter values into sql-string instead of using preparedstatement parameters --- M src/org/openbravo/erpCommon/utility/TableSQLData.java --- |
|
(0017593) shuehner (administrator) 2009-06-25 17:11 |
@qa: this change affects all generated windows in edit & grid view. - Navigation: first/previous/next/last - grid edit->grid & grid->edit view - scrolling in edit view (check for no duplicate rows, and no missing rows) -- all three above with different sort order/filter/language (en_us + one more) |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-25 16:36 | shuehner | New Issue | |
| 2009-06-25 16:36 | shuehner | Assigned To | => shuehner |
| 2009-06-25 16:36 | shuehner | Status | new => scheduled |
| 2009-06-25 16:36 | shuehner | fix_in_branch | => pi |
| 2009-06-25 16:55 | hgbot | Checkin | |
| 2009-06-25 16:55 | hgbot | Note Added: 0017590 | |
| 2009-06-25 16:55 | hgbot | Status | scheduled => resolved |
| 2009-06-25 16:55 | hgbot | Resolution | open => fixed |
| 2009-06-25 16:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/79d24670c33942d5d80fb61c7d09440e9f6e782d [^] |
| 2009-06-25 17:11 | shuehner | Note Added: 0017593 | |
| 2009-07-21 16:24 | psarobe | Fixed in Version | => 2.50MP3 |
| 2009-07-21 16:26 | psarobe | Tag Attached: 250MP3releasecandidate | |
| 2009-07-21 18:43 | psarobe | Tag Attached: leo | |
| 2009-07-22 06:30 | elopio | Status | resolved => closed |
| 2009-07-23 00:00 | anonymous | sf_bug_id | 0 => 2825605 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |