diff options
| author | Terry Truong <terry06890@gmail.com> | 2023-01-04 13:07:33 +1100 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2023-01-04 13:07:33 +1100 |
| commit | a6a3616042414eb3c18611eaca58cbcc62c86eaa (patch) | |
| tree | cc303d5c79dc4408b678de7800816d5cd09273f8 /backend/hist_data/gen_events_data.py | |
| parent | ee935784ccdf6e75a853f80b78dac6bf7fb95fbe (diff) | |
Add database index events_id_start_idx
Diffstat (limited to 'backend/hist_data/gen_events_data.py')
| -rwxr-xr-x | backend/hist_data/gen_events_data.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/hist_data/gen_events_data.py b/backend/hist_data/gen_events_data.py index deaf794..ee2fdc1 100755 --- a/backend/hist_data/gen_events_data.py +++ b/backend/hist_data/gen_events_data.py @@ -177,6 +177,7 @@ def genData(wikidataFile: str, offsetsFile: str, dbFile: str, nProcs: int) -> No dbCur = dbCon.cursor() dbCur.execute('CREATE TABLE events (id INT PRIMARY KEY, title TEXT UNIQUE, ' \ 'start INT, start_upper INT, end INT, end_upper INT, fmt INT, ctg TEXT)') + dbCur.execute('CREATE INDEX events_id_start_idx ON events(id, start)') if nProcs == 1: with bz2.open(wikidataFile, mode='rb') as file: for lineNum, line in enumerate(file, 1): |