[sqlalchemy] Re: `func.similarity` performance

2016-04-01 Thread Jonathan Vanasco
if you can put together a self-contained repeatable example that triggers this, i'd be happy to take a look. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to

[sqlalchemy] Re: `func.similarity` performance

2016-04-01 Thread Robert Smith
Jonathan and Sergey: I tried to use the `op()` method but for some reason it fails in this particular query (session.query(Model).filter(Model.description.op('%')('string'))). I get the following error: /home/user/anaconda/envs/gensim/lib/python3.5/site-packages/sqlalchemy/engine/default.py

Re: [sqlalchemy] `func.similarity` performance

2016-04-01 Thread Robert Smith
Mike Bayer: Thank you for your explanation. Yes, I thought `func.XYZ` was more aware of its functions. In the case of `%` and indexes, I think there is an improvement if there is an index, but the query still works as usual even in the absence of an index. However, if the implementation is not

Re: [sqlalchemy] scoped_session, sessions and thread safety

2016-04-01 Thread Mehdi GMIRA
Le vendredi 1 avril 2016 02:30:21 UTC+2, Mike Bayer a écrit : > > > > On 03/31/2016 10:38 AM, Mehdi GMIRA wrote: > > > > > > > > 1) One limitation that i find to the scoped_session is that > you're > > > limited to exactly one session by thread. > > > > that's not true