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
_______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-framework Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-framework More help : https://help.launchpad.net/ListHelp
