On Dec 3, 2012, at 5:06 AM, Albert Cervera i Areny <alb...@nan-tic.com> wrote:
> A Diumenge, 2 de desembre de 2012 17:16:49, Teagarden va escriure: > > On Dec 2, 2012, at 7:35 PM, Cédric Krier <cedric.kr...@b2ck.com> wrote: > > > It could be possible to cache the default_get method but I'm not sure it > > > is a correct solution. I think it is better to say, you have to create > > > the singleton. Also I think it is the Property field that are slow and > > > they should be replace by explicit Function field using a new table with > > > real foreign key. > > > > Property fields are probably one of the slowest components and the > > bottleneck appears to be the entity attribute value model on ir.property > > Further testing, now with product.product, shows that translatable fields > also impose a huge overhead. Writing a thousand 1000 products takes as much > as 60 seconds with single insert and 112 seconds with multiple inserts > implementations. Part of the problem is the inheritance but that almost only > affects the multiple inserts implementation. In the single insert version ~57 > seconds are spent adding the translations. Could it be the index [1] ? > > I have created a new page [1] to collect tips and possible improvements in > terms of performance. > > [1] http://code.google.com/p/tryton/wiki/Performance Very useful [1] http://hg.tryton.org/2.6/trytond/file/0b939dff8340/trytond/ir/translation.py#l77 Thanks Sharoon Thomas Openlabs Technologies & Consulting (P) Limited w: http://www.openlabs.co.in m: +1 813.793.6736 (OPEN) Extn. 200 t: @sharoonthomas - We CARE for our customers -- -- tryton-dev@googlegroups.com mailing list