Hi, Some more performance/scalability news......
To do some scalability tests, I wrote two scripts to general large number of partners (& addresses), and invoices via the XML-RPC interface. Basically you just tell the partners script how many partners you want to create, and the invoice script will create one invoice for each partner. I can make the scripts available, if there is interest - peer review would be interesting. (where should I put them? they are not addons/modules, just scripts). Now, for some tests results: The input: 1. 100'000 partners with each having one address was inserted 2. one invoice, with 5 detail lines was created for each customer. Conclusions so far: - Openerp keeps running, interactive response is fine. No obvious memory leaks or stability issues. The linux server does not slow down on the shell level either. - CPU & disk IO seem to be the bottlenecks. - The Openerp process uses most CPU, up to twice that of postgres. - The load scripts have not been optimised for speed, they could probably run much faster. SERVER: - The test server was a virtual machine on Vmware ESX. When inserting partners/invoices the load stayed more or less constant... 2.2GHz CPU 75% loaded, Disk 2Mbs, Memory 512MB - Ubuntu 8.04, Openerp 5.0.2 An example "top" output shows the cpu and memory usage: > Tasks: 65 total, 2 running, 63 sleeping, 0 stopped, 0 zombie > Cpu(s): 33.9%us, 55.7%sy, 0.0%ni, 0.0%id, 6.0%wa, 0.0%hi, 4.4%si, 0.0%st > Mem: 515448k total, 282300k used, 233148k free, 14676k buffers > Swap: 0k total, 0k used, 0k free, 173668k cached > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 4650 postgres 20 0 93484 27m 4716 S 56.7 5.4 4:29.05 openerp-server. > 1182 postgres 20 0 38580 12m 10m S 39.3 2.5 0:22.06 postgres > 5689 root 20 0 8504 6128 2480 S 8.0 1.2 0:39.32 python > 4226 postgres 20 0 10432 2548 428 S 1.0 0.5 0:05.03 postgres It took 4 hours to add 100k invoices, customers were create at about 1000 per minute. Regards, Sean -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=42798#42798 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
