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

Reply via email to