Hello, > 1. Do we have tested this ERP on 1/2 Millon records in Master and Transaction > Data ?
This is not an easy question to reply to. Every Open ERP integration is different, it depends a lot on the modules you installed and your server configuration. Some have been used in very big environment, others need some improvement to be used in very big databases. We are working today on a direct marketing customer that have 2.000.000 customers. We don't have too much problems, but some code had to be tweaken. We also have a customer that generates 1.000 stock move per day; some queries goes up to 2 seconds but not more. But note that we work on speed improvement issues since months to constantly improve performance of Open ERP. It has been a priority since you (and others) reported problems. Some of the biggest announcements related to this: * Complete Web Client Rewrite: http://openerp-team.blogspot.com/2009/05/openerp-web-whats-going-on.html (based on this report, we continued and succeeded to divide times by 3, which lead to 7x faster web client 5.0.2, compared to version 5.0.0. * Report Engine, fully rewritten, one month ago: (the same report goes from 1 min 40 sec to 9 seconds.) http://openerp-team.blogspot.com/2009/05/r-feedback-of-april-09.html * Nested Trees computation (mainly used in accounting and stock) and function fields improvement: http://fptiny.blogspot.com/2008/08/latest-changes-in-framework.html * Accounting Speed Improvement: http://fptiny.blogspot.com/2008/08/accounting-speed-improvement.html We also did lots of speed improvement on particular bug reports, on specific modules. You can get the list on launchpad. > 2. What is the solution of Representation of Data on Screen other than report > (PDF) ? Because PDF is not require at all time when user needs a report ... > May be on Screen Balance Sheet / ledger / Stock report is required printed on > Listview / Grid format > > I think OpenERP is using only PDF as an output tool/ report representation > tool and its consuming more time than require. Our PDF engine (since it has been rewritten a few weeks ago) is very efficient and performance are much more better. By default, Open ERP support the following report engine: * RML -> PDF (default one, quite fast, since latests rewrite) * RML -> HTML (do not guarantee a perfect layout) * ODT -> ODT (good layout but slow due to Open Office) * HTML -> HTML (using mako templates, available since 4 weeks) For new HTML report engine: http://openerp-team.blogspot.com/2009/05/faster-formating-of-html-reports-using.html > 3. Do you have tested Load/ Stress testing on OpenERP for Web Client as well > as Desktop Client. If 200 Users can log in to ERP server on same time .. Is > the OpenERP capable to handle this. (We Need report on that) Yes, the number of users is not a real problem. Our online demo server goes up to 600 users in real time but with a few data. The real difficulty is the number of records in the database and the module you use. -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=38428#38428 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
