On 12 Nov 2017, at 4:05pm, Balaji Ramanathan <balaji.ramanat...@gmail.com> wrote:
> Is there anything I can do to reduce the time taken? Do it in your favourite programming language rather than SQL. Congratulations on finding a way of doing it in SQL, but running sums and averages are trivial in a programming language and will be far faster and you can be as fussy as you like about whether nulls are counted and such things. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users