Re: [tryton-dev] Performance problems with 2.6

2013-05-28 Thread Ian Wilson
Hi everybody, Just to follow up, upgrading from tryton 2.6 to tryton 2.8 improved the total speed to pay an invoice + ship a shipment + finish a sale by 5 to 10 times without any algorithm changes in my custom modules (ie. I just needed to upgrade them to 2.8). It was taking 70+ seconds(all combi

Re: [tryton-dev] Performance problems with 2.6

2013-04-23 Thread Guillem Barba Domingo
El 23/04/2013 22:32, "Albert Cervera i Areny" va escriure: > > A Dilluns, 22 d'abril de 2013 11:24:15, Udo Spallek va escriure: > > > We could try a test script and measuring the pystones. > > > It is a whetstone[1] implementation for python and found in the stdlib > > > *test*. > > > The idea is

Re: [tryton-dev] Performance problems with 2.6

2013-04-23 Thread Albert Cervera i Areny
A Dilluns, 22 d'abril de 2013 11:24:15, Udo Spallek va escriure: > Wed, 17 Apr 2013 09:15:37 +0200 > > Cédric Krier : > >On 16/04/13 20:54 -0700, Ian Wilson wrote: > >> Is tryton tested against large datasets? I can imagine datasets > >> might have 1-1 parties as well. > >> Maybe if a tes

Re: [tryton-dev] Performance problems with 2.6

2013-04-22 Thread Udo Spallek
Wed, 17 Apr 2013 09:15:37 +0200 Cédric Krier : >On 16/04/13 20:54 -0700, Ian Wilson wrote: >> Is tryton tested against large datasets? I can imagine datasets >> might have 1-1 parties as well. >> Maybe if a test script was setup for performance testing (only >> against official modules)

Re: [tryton-dev] Performance problems with 2.6

2013-04-17 Thread Cédric Krier
On 16/04/13 20:54 -0700, Ian Wilson wrote: > Is tryton tested against large datasets? I can imagine datasets might have > 1-1 parties as well. > > Maybe if a test script was setup for performance testing (only against > official modules) it would be easier for me to tell if my custom

Re: [tryton-dev] Performance problems with 2.6

2013-04-16 Thread Ian Wilson
On Tuesday, April 16, 2013 12:15:53 AM UTC-7, Cédric Krier wrote: > > On 15/04/13 21:00 -0700, Ian Wilson wrote: > > I tried to turn on sql logging with Transaction().cursor.sql_log = True > at > > the start of my do_process method. I'm not sure if there is a better > way > > and that will

Re: [tryton-dev] Performance problems with 2.6

2013-04-16 Thread Cédric Krier
On 15/04/13 21:00 -0700, Ian Wilson wrote: > I tried to turn on sql logging with Transaction().cursor.sql_log = True at > the start of my do_process method. I'm not sure if there is a better way > and that will work. I modified the code to also track updates and keep > track of queries that di

Re: [tryton-dev] Performance problems with 2.6

2013-04-15 Thread Ian Wilson
On Monday, April 15, 2013 9:00:25 PM UTC-7, Ian Wilson wrote: > > > > On Monday, April 15, 2013 10:37:12 AM UTC-7, Cédric Krier wrote: >> >> On 15/04/13 09:36 -0700, Ian Wilson wrote: >> > Hello people of Tryton, >> > >> > I'm experiencing performance problems and had some questions about >>

Re: [tryton-dev] Performance problems with 2.6

2013-04-15 Thread Ian Wilson
On Monday, April 15, 2013 10:37:12 AM UTC-7, Cédric Krier wrote: > > On 15/04/13 09:36 -0700, Ian Wilson wrote: > > Hello people of Tryton, > > > > I'm experiencing performance problems and had some questions about them. > > > > I have a wizard that works like a sales register for retail sal

Re: [tryton-dev] Performance problems with 2.6

2013-04-15 Thread Cédric Krier
On 15/04/13 09:36 -0700, Ian Wilson wrote: > Hello people of Tryton, > > I'm experiencing performance problems and had some questions about them. > > I have a wizard that works like a sales register for retail sales. It > works as follows: > > An employee enters in a list of products, their qu

[tryton-dev] Performance problems with 2.6

2013-04-15 Thread Ian Wilson
Hello people of Tryton, I'm experiencing performance problems and had some questions about them. I have a wizard that works like a sales register for retail sales. It works as follows: An employee enters in a list of products, their quantities and optionally new prices and then clicks process