one of my customers has some 30.000 products (also we do not use OpenERP "products" for this) and there is no performance issue as long as the data are not displayed in * one2many * many2many widgets (tested on GTK)
top level objects limit the number of displayed records to 80 (GTK) or 20 (WEB) but the 2 other widgets don't . opening a many2many widget WITHOUT entering selection criteria transfers all records to the client. you might test this behavior with the medical module > http://medical.sourceforge.net/ having classified some 15000 diseases having some 1000 records in one2many widget causes severe server load - but this can be circumvented by replacing these o2m widgets with an action like "All tasks" in "All Projects" see also > https://blueprints.launchpad.net/openobject-server/+spec/many2many-performance > https://blueprints.launchpad.net/openobject-server/+spec/performance-optimization -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=31411#31411 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
