Why seconds write is faster than first write

[Raimon Esteve]

Hie,

I tested executions times and I see the first time to write is slower
than next writes.

Scenario:

1- Go to parties, change form view
2- Edit and save -> 8.414 seconds
3- reedit or change to other party and save -> ~0.041 seconds
4- Logout and login. Go to parties and edit other party. Save other
party -> ~0.041 seconds

Is it about cache methods? Why?

Details:

Product write:

First edit time -> 210548 function calls (188193 primitive calls) in
0.286 seconds
Second edit time -> 71120 function calls (61464 primitive calls) in
0.102 seconds
Third edit time -> 78458 function calls (68428 primitive calls) in
0.107 seconds
....

Party write:

First edit time -> 15681456 function calls (12900244 primitive calls)
in 8.414 seconds
Second edit time -> 130757 function calls (120197 primitive calls) in
0.212 seconds
Third edit time -> 10610 function calls (9545 primitive calls) in 0.041 seconds
Fourth edit time 10610 function calls (9545 primitive calls) in 0.017 seconds
.....

Thanks,

Raimon

[Cédric Krier]

On 2016-02-03 17:09, Raimon Esteve wrote:
> Hie,
>
> I tested executions times and I see the first time to write is slower
> than next writes.
>
> Scenario:
>
> 1- Go to parties, change form view
> 2- Edit and save -> 8.414 seconds
> 3- reedit or change to other party and save -> ~0.041 seconds
> 4- Logout and login. Go to parties and edit other party. Save other
> party -> ~0.041 seconds
>
> Is it about cache methods? Why?

Probably as you did not describe precisely you benchmark setup.
Also as 8 seconds is very huge, I suspect you did not even test using a
preloaded database.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/