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)