c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <750194@xxxxxxxxxxxxxxxxxx>]

Hello Vicente,

Thank you for sharing your test script, the results are interesting!

Unfortunately these bare results are not very usable unless we can
reproduce them, and look if there's a problem.

Using an empty database with just the 'base' module installed, I do not
see this behavior at all, instead I see the following results, where v5
and v6 have almost the same numbers:

# v5
$ python EstresOpenErp.py -db test_db -c admin -p 8069 -o crear_cliente,300 -v -url http://localhost
Create client  , Total:   7.068556
Create client  , Media:   0.023352
Create client  , de   :   0.016538
Resultados
Operacion       Veces      Total      Media      Varianza   Voltas    
Create client          300   7.068556   0.023352   0.016538        300 
Tempo total: 7.068886

# v6
$ python EstresOpenErp.py -db test_db -c admin -p 8069 -o crear_cliente,300 -v -url http://localhost
(...)
Create client  , Total:   7.300302
Create client  , Media:   0.024128
Create client  , de   :   0.023991
Resultados
Operacion       Veces      Total      Media      Varianza   Voltas    
Create client          300   7.300302   0.024128   0.023991        300 
Tempo total: 7.300566

As you can see, the results are so close than normal variation of CPU usage can easily account for them.
This is good because it shows that there is no "global" performance variation in v6, compared to v5.

Could you tell us which modules you have installed in v5 and which
modules you have installed in v6 (presumably the same or equivalent?),
in order to produce this behavior. Maybe one of them does something
specific to partners or addresses that would explain your results?

Also, you appear to be using Windows, and the TCP implementation in
Windows is known to have strange behaviors, so you should try the same
test on Linux too, to make sure the results do not depend on the
platform (my tests were on Ubuntu,both server and test script).

As a reference, I am attaching the full debug log of the creation of one
pair partner + address, in v5 and v6. The timings for these were 35 and
60 ms, and are certainly influenced by the very verbose log level. The
tests above were done using the default INFO log level.

Thanks!


PS: it is usually a good practice to always write your code in english (method names, variables, even comments), so that it can be readily shared with any programmer in the world... you never know when you will need to reuse it or who might need to read it ;-)

** Changed in: openobject-server
       Status: New => Incomplete

-- 
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