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 [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.
