Can i use ORM many-to-many relations and filter SQL -side? If i can't, can you give me an example on how i should use many-to-many relations with filtering in SQLAlchemy?
-- K On Apr 2, 1:36 pm, svilen <[EMAIL PROTECTED]> wrote: > > After getting the results, i will filter them with Python filters, > > as i don't know how to filter many-to-many queries directly. > > > Should i somehow make custom queries that handles many-to-many > > relationships etc. or is there something else i'm missing that > > makes the system slow? I have ran the bench with MySQL and > > PostgreSQL engines, the result is the same. When running with a > > profiler, at least ~90% of the time is taken by SQLAlchemy. > > one general suggestion, try to move the filtering on the sql side; > thus u'll have less data transferred then instantiated then > filtered - which is probably eating most of the time. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
