Project

General

Profile

« Previous | Next » 

Revision 2846

sql.py: flatten(): Add indexes on the created table so its columns can be used in an O(n) merge join

View differences:

sql.py
742 742
    items = mk_flatten_mapping(db, into, cols, as_items=True, **kw_args)
743 743
    cols = [sql_gen.NamedCol(new.name, old) for old, new in items]
744 744
    run_query_into(db, mk_select(db, joins, cols, limit=limit, start=start),
745
        into=into)
745
        into=into, add_indexes_=True)
746 746
    return dict(items)
747 747

  
748 748
def mk_track_data_error(db, errors_table, cols, value, error_code, error):

Also available in: Unified diff