> 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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---