[sqlalchemy] Are primary_key fields immutable?

2006-12-28 Thread david mugnai
Should the session.update call raise an error? --- import sqlalchemy as sa engine = sa.create_engine('sqlite:///') metadata = sa.BoundMetaData(engine) usersTable = sa.Table('users', metadata, sa.Col

[sqlalchemy] Re: Performance of data mapping and plain access

2006-12-28 Thread david mugnai
Michael Bayer wrote: [snip] actually a lot better than they've been in the past. if your tests are useful, I might add them as well (but note that your attachments didnt come through, so try again). I forgot the attachments, sorry. Please find them here: http://d2.spacespa.it:8000/temp/test

[sqlalchemy] Performance of data mapping and plain access

2006-12-27 Thread david mugnai
Hi all, while trying the ORM side of sqlalchemy, I noticed a remarkable speed difference between using the ORM machinery and the "plain" db access. The attached test consists of 1000 inserts and 1000 selects; its purpose is just to test the overhead of the data mapping system. The ORM version t