@Simon : Yes there is an index. The raw query CREATE TEMP TABLE uniqdt AS SELECT DISTINCT calc_date FROM securities;
runs exactly 1.2 seconds. @Luuk : Yes, there is a non recursive solution, but it is slower than the recursive solution, by a factor of about 2. On Sat, Sep 12, 2015 at 4:14 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 12 Sep 2015, at 9:14pm, Simon Slavin <slavins at bigfraud.org> wrote: > > > Do you have an index on calc_date ? If not, make one. > > Uh ... and then run ANALYZE. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Aurel Wisse (514) 814-5421
