c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Tuesday 05 April 2011, you wrote:
> Sorry, I restart server v6 and results matched.
> I adjunt script stress translated into English.
> 
> 
> ** Attachment added: "stres_openerp.py"
>   
> https://bugs.launchpad.net/openobject-server/+bug/750194/+attachment/19836
> 68/+files/stres_openerp.py

Thank you for the script!

I run that and got results
OS: Mageia Linux 1 α2
Python 2.7, psycopg 2.4
Postgres 9.0.2+
System: Core2Duo T5470  @ 1.60GHz, 3GB RAM, (mobile, with 2.5'' disk)
OpenERP: pg84-next, 111c4375c8a8b

1st test, with full db after test-bqi, 166 loaded modules:
Operation       Times      Total      Average    Variance   Real Times
Create partner         300  15.202521   0.050372   0.007364        300 
Total time: 15.202541

2nd test, same, with cache.enable=True (note, we are admin, still)

Operation       Times      Total      Average    Variance   Real Times
Create partner         300  17.987713   0.059673   0.012449        300 
Total time: 17.987732

3rd test, after resetting the db to a new one, no modules.
Operation       Times      Total      Average    Variance   Real Times
Create partner         300   6.476113   0.021326   0.019839        300 
Total time: 6.476127

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/750194

Title:
  Openerp v6.0 is 10 times slower than v5.0

Status in OpenERP Server:
  Incomplete

Bug description:
  Test vs v5.0
  $  /cygdrive/c/dev/Python26/python.exe  EstresOpenErp.py -db pruebas -c admin -p 8069 -o crear_cliente,300 -v -url http://openerpv5
  300 operations to do.
  Starting test
  Results
  Operation       Times      Total      Avg      Variance
  Create client          300   6.156000   0.020367   0.012112
  Total time: 6.156000

  Test vs v6.0
  $  /cygdrive/c/dev/Python26/python.exe  EstresOpenErp.py -db pruebas -c admin -p 8069 -o crear_cliente,300 -v -url http://openerpv6
  300 operations to do.
  Starting test
  Results
  Operation       Times      Total      Avg      Variance
  Create client          300  82.703000   0.275520   0.034198
  Total time: 82.703000