You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The current approach (_copy_data) for loading data from the source database relies on limit + offset, which is slow. Replace it with a faster approach, perhaps using yield_per or a window function. e.g.:
for data in source_session.query(table).yield_per(batchsize):
_insert_data(target_session,source_schema,table,data)
The current approach (
_copy_data
) for loading data from the source database relies on limit + offset, which is slow. Replace it with a faster approach, perhaps using yield_per or a window function. e.g.:See:
The text was updated successfully, but these errors were encountered: