[sqlalchemy] Precompiled queries and .get(ident)

2014-12-02 Thread Laurence Rowe
I've been experimenting with precompiled queries in my app using the second recipe on https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/BakedQuery. I'm seeing a big speed up, with pages 30-40% faster (my application has graph structured content so some pages require ~100 items.) But

Re: [sqlalchemy] Precompiled queries and .get(ident)

2014-12-02 Thread Michael Bayer
On Dec 2, 2014, at 4:32 PM, Laurence Rowe laurencer...@gmail.com wrote: I've been experimenting with precompiled queries in my app using the second recipe on https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/BakedQuery. I'm seeing a big speed up, with pages 30-40% faster (my