Openbravo Issue Tracking System - Java Client POS | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007624 | Java Client POS | (No Category) | public | 2009-02-18 13:25 | 2011-06-03 12:21 |
| Reporter | uwe47 | ||||
| Assigned To | adrianromero | ||||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | scheduled | Resolution | open | ||
| Platform | OS | 10 | OS Version | XP 32 Bit SP3 | |
| Product Version | 2.20 | ||||
| Target Version | 2.40 | Fixed in Version | |||
| Regression date | |||||
| Regression introduced by commit | |||||
| Regression level | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression introduced in release | |||||
| Summary | 0007624: Catalog function fails with large number of products | ||||
| Description | The catalog function fails (i.e. stock diary and stock maintenance don't work (nothing happens after pressing the respective buttons) and in the sales window you can't change categories anymore) after adding a large number of products (about 5000) to the catalog. (NOTE: the problem is NOT the number of products imported into Openbravo POS by itself but the number of products added to the CATALOG) | ||||
| Steps To Reproduce | - Add a total of about 5.000 products (organized in 4 categories of about 800 to 1500 products each) to the database (load into PostgreSQL from CSV file); AND - Add all products to the catalog (by adding the product ids to products_cat.product) The total number of products by itself doesn't seem to be the problem - only if you add them to the catalog. Without adding them to the catalog Openbravo POS slows down only a little bit on startup, even with all 5000 products imported. Trying to add the products to the catalog category by category results in an increasing slowdown of Openbravo POS (on startup and on changing screens) after each added category. And Openbravo POS will only work with no more than a total of two categories added to the catalog (no matter which categories or how many products exactly belong to each category (varying from 800 to 1500, see above)). After adding a third category, the described problem will always occur. And it's the same on both PostgreSQL and MySQL. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-02-18 13:25 | uwe47 | New Issue | |||
| 2009-02-23 10:49 | adrianromero | Status | new => scheduled | ||
| 2009-02-23 10:49 | adrianromero | Assigned To | => adrianromero | ||
| 2009-02-23 10:49 | adrianromero | fix_in_branch | => trunk | ||
| 2009-03-02 15:52 | adrianromero | Target Version | => 2.30 | ||
| 2009-03-02 15:52 | adrianromero | fix_in_branch | trunk => | ||
| 2009-03-23 17:18 | adrianromero | Note Added: 0014869 | |||
| 2009-03-23 17:18 | adrianromero | Priority | normal => low | ||
| 2009-03-23 17:18 | adrianromero | Severity | major => minor | ||
| 2009-03-23 17:18 | adrianromero | Target Version | 2.30 => | ||
| 2009-04-01 16:30 | adrianromero | Target Version | => 2.40 | ||
| 2011-06-03 11:01 | dalsasua | Assigned To | adrianromero => dalsasua | ||
| 2011-06-03 12:21 | dalsasua | Assigned To | dalsasua => adrianromero | ||
| 2012-11-07 09:40 | priyam | Category | 01 - General => (No Category) | ||
| Notes | |||||
|
|
|||||
|
|
||||