Re: [sqlalchemy] Performance questions on semi-large result sets

2015-10-22 Thread Gaëtan de Menten
On Wed, Oct 21, 2015 at 11:43 PM, Mike Bayer wrote: > If we OTOH use native_unicode=False and use the Unicode type for the > columns we care about, that seems a lot faster, e.g. changing the > mapping to: [...] > When we use the Unicode type and set

Re: [sqlalchemy] Performance questions on semi-large result sets

2015-10-21 Thread Mike Bayer
On 10/21/15 4:52 PM, Uri Okrent wrote: > Hello, I'm trying to understand the various performance implications of > working with the ORM layer, vs the SQL language layer, vs a raw dbapi > connection. Ideally, I would like to stick with the ORM layer > > First, the set up: > CentOS 6 >

Re: [sqlalchemy] Performance questions on semi-large result sets

2015-10-21 Thread Mike Bayer
On 10/21/15 7:27 PM, Uri Okrent wrote: > Interesting... > > On Wednesday, October 21, 2015 at 5:43:22 PM UTC-4, Michael Bayer wrote: > > class Customer(Base): > __tablename__ = "customer" > id = Column(Integer, primary_key=True) > name = Column(Unicode(255)) >

Re: [sqlalchemy] Performance questions on semi-large result sets

2015-10-21 Thread Uri Okrent
Interesting... On Wednesday, October 21, 2015 at 5:43:22 PM UTC-4, Michael Bayer wrote: > > class Customer(Base): > __tablename__ = "customer" > id = Column(Integer, primary_key=True) > name = Column(Unicode(255)) > description = Column(Unicode(255)) > My declarative classes