On 12 Nov 2017, at 4:05pm, Balaji Ramanathan <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
