[sqlalchemy] Re: Performance of data mapping and plain access - Michael Bayer - com.googlegroups.sqlalchemy

10 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Performance of data ...

From	Sent On	Attachments
david mugnai	27 Dec 2006 11:56
Michael Bayer	27 Dec 2006 12:29
Lele Gaifax	27 Dec 2006 12:55
Michael Bayer	27 Dec 2006 14:13
Michael Bayer	27 Dec 2006 22:37
david mugnai	28 Dec 2006 01:55
Sébastien LELONG	28 Dec 2006 06:06
Michael Bayer	28 Dec 2006 08:28
Sébastien LELONG	28 Dec 2006 09:12
Michael Bayer	29 Dec 2006 08:31

Subject:	[sqlalchemy] Re: Performance of data mapping and plain access
From:	Michael Bayer (zzz...@gmail.com)
Date:	12/27/2006 02:13:02 PM
List:	com.googlegroups.sqlalchemy

dbrow seems to be exactly what ResultProxy already does (which has no speed problems).

the answer is in optimizing the "copy" made of each object's state upon load. step 1 is to make that an optional step, do some speed tests to insure that it speeds things up when disabled, step 2 is to possibly make that "copy" only take place when you actually modify the loaded object, so that the load operation is fast.