Re: [sqlalchemy] how to prepare "get by primary key" query?

2013-04-04 Thread Roman Yakovenko
On Wed, Apr 3, 2013 at 5:47 PM, Michael Bayer wrote: > > the Python DBAPI doesn't have an explicit concept of a "prepared > statement" - the idea of preparing a statement involves that a statement > handle is established on the database server, which can then be reused. > The closest the DBAPI has

[sqlalchemy] how to prepare "get by primary key" query?

2013-04-02 Thread Roman Yakovenko
Hello. I am just starting with SQLAlchemy and have a small problem: my "get" query is compiled every time I use it. According to cProfile: ncalls tottime percall cumtime percall filename:lineno(function) 100.0000.0000.0020.000 /usr/local/lib/python2.7/dist-packages/SQLAlchem