Hi, I have a database with 1.2M rows at this point (in the main table - and even more rows in the one to many associated tables). I am trying to load the main table joined with a column from one of the associated table:
query = db.session.query(Employee).\ options(joinedload(Employee.boss)).\ filter(and_(Employee.id>=FIRST_PATENT,Employee.id<end)).\ order_by(Employee.id) I have a MacBook Air. So far it has taken over 12 hours and it is still not done. Any idea how long such a process can take and how to accelerate it? Rivka -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.