openerp-expert-framework team mailing list archive

[ferdinand <office@xxxxxxxxxx>]

Hello!

please see also my posts dated Aug 14th 2012
http://www.openerp.com/forum/post111629.html

Quote
> I just traced the SQL statements 
> for every insert of a SO Line 43 (a prime number hence no carthesian
> product) identical selects are done.
> I could imagine that for every function field or for each on change
> trigger a 
> "for line in sale_order_line:" or similar
> is executed explicitly
>
> IMHO inside a transaction a re-read of a line must only happen after a
> DB-write of the current process, as the content can not change otherwise.
>
> caching the results of the first read would dramatically increase
> performance

thanks for looking into this