Re: [sqlalchemy] .any() queries and MySQL performance

2015-06-11 Thread Eric Ogren
On Wednesday, June 10, 2015 at 9:00:13 PM UTC-7, Michael Bayer wrote: On 6/10/15 10:32 PM, Eric Ogren wrote: Hello, snip Is there a good way to leverage the .any() filter in MySQL? I can sort of work around this by doing something like:

[sqlalchemy] .any() queries and MySQL performance

2015-06-10 Thread Eric Ogren
Hello, I have a very simple data model with a one to many relationship - a thread could have many identifiers that link to it: class Thread(Base): __tablename__ = 'threads' id = Column(Integer, primary_key=True) link = Column(String(length=512, collation=UTF8),

Re: [sqlalchemy] .any() queries and MySQL performance

2015-06-10 Thread Mike Bayer
On 6/10/15 10:32 PM, Eric Ogren wrote: Hello, I have a very simple data model with a one to many relationship - a thread could have many identifiers that link to it: class Thread(Base): __tablename__ = 'threads' id = Column(Integer, primary_key=True) link =