News has a TEXT column [content] which is in average about 5000 in
length.
So ye, u found the problem :)
And how to overcome (workaround) this in sqlalchemy?
On 25 feb., 00:42, Michael Bayer mike...@zzzcomputing.com wrote:
On Feb 24, 2010, at 6:15 PM, dusans wrote:
Hi. I got this simple
I've profile it
1. Session.query: 2.8 seconds
2. Session.execute: 2.6 seconds
3. sqlite.execute: 2.6 seconds
4. If u run it directly via Sqlite Gui client (SQLite Expert) then i
get: 50 ms
Maybe its using some kind of cache.
On 25 feb., 00:42, Michael Bayer mike...@zzzcomputing.com
you can skip the loading of that column using deferred(), for example.
still, 5000 * 8 is only 40K. should be well under 200 ms.
On Feb 25, 2010, at 4:10 AM, dusans wrote:
News has a TEXT column [content] which is in average about 5000 in
length.
So ye, u found the problem :)
And how to