Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0007624 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Java Client POS] (No Category) | minor | always | 2009-02-18 13:25 | 2011-06-03 12:21 | |||||||
Reporter | uwe47 | View Status | public | |||||||||
Assigned To | adrianromero | |||||||||||
Priority | low | Resolution | open | Fixed in Version | ||||||||
Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | 2.40 | |||||||
OS | Windows | Database | PostgreSQL | Java version | 1.6..0_11 | |||||||
OS Version | XP 32 Bit SP3 | Database version | 8.3.5 | Ant version | 1.7.0 | |||||||
Product Version | 2.20 | SCM revision | ||||||||||
Regression date | ||||||||||||
Regression introduced by commit | ||||||||||||
Regression level | ||||||||||||
Review Assigned To | ||||||||||||
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. | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0014869) adrianromero (manager) 2009-03-23 17:18 |
When there are a big number of products in the database Openbravo POS running under Linux throws the following exception: java.lang.OutOfMemoryError: GC overhead limit exceeded at sun.awt.X11.XDecoratedPeer.handleConfigureNotifyEvent(XDecoratedPeer.java:752) at sun.awt.X11.XBaseWindow.dispatchEvent(XBaseWindow.java:1122) at sun.awt.X11.XBaseWindow.dispatchToWindow(XBaseWindow.java:1079) at sun.awt.X11.XToolkit.dispatchEvent(XToolkit.java:475) at sun.awt.X11.XToolkit.run(XToolkit.java:588) at sun.awt.X11.XToolkit.run(XToolkit.java:523) at java.lang.Thread.run(Thread.java:619) To fix this issue will involve to modify the functionality in several areas to manage large amounts of records like pagination, and this is something we will not afford in this version. |
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) |
Copyright © 2000 - 2009 MantisBT Group |