A Divendres 13 Febrer 2009, [email protected] va escriure: > 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
Have you tested this with Koo. Koo loads data on demand by default, and you should not have those problems, as long as you have the appropiate indexes in the database. It should work reasonably well even over the Internet using the new Pyro protocol. If you give it a try, tell us how it worked! > 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-perfor > >mance > > > > > > > > https://blueprints.launchpad.net/openobject-server/+spec/performance-opti > >mization > > -------------------- m2f -------------------- > > -- > http://www.openobject.com/forum/viewtopic.php?p=31411#31411 > > -------------------- m2f -------------------- > > > _______________________________________________ > Tinyerp-users mailing list > http://tiny.be/mailman/listinfo/tinyerp-users -- Albert Cervera i Areny http://www.NaN-tic.com _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
