On 12 Nov 2017, at 4:05pm, Balaji Ramanathan <balaji.ramanat...@gmail.com>
> 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.
sqlite-users mailing list