entrouvert
/
wcs-olap
16
0
Fork 0
Code Issues Pull Requests Releases Activity

add index on dates (#51681)

This commit is contained in:
Frédéric Péters 2021-03-04 21:01:29 +01:00
parent 1dc7fb5833
commit 1640abbfdc
1 changed files with 1 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

1
wcs_olap/feeder.py
View File

@ -380,6 +380,7 @@ class WcsOlapFeeder(object):
def do_dates_table(self):
self.ex('CREATE TABLE IF NOT EXISTS public.dates (date date, day text, month text)')
self.ex('CREATE INDEX IF NOT EXISTS dates_index ON public.dates (date)')
self.ex('SELECT MIN(date) FROM public.dates')
max_date = self.cur.fetchone()[0]