Re: [sqlite] Running sums and averages

2017-11-15 Thread Dennis Clarke
Memory is cheap and most servers have plenty. Processors are fast and most servers have multiple with many cores. Select the entire table of columns you need into memory. Write a little code. No it won't scale very well into millions of rows but I could easily

Re: [sqlite] Running sums and averages

2017-11-13 Thread Balaji Ramanathan
; Cc: > Bcc: > Date: Sun, 12 Nov 2017 16:37:24 + > Subject: Re: [sqlite] Running sums and averages > > > 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? >

Re: [sqlite] Running sums and averages

2017-11-13 Thread David Raymond
As other folks have mentioned, doing it in an external language is going to be easiest. That being said, CTE's are almost a full language in themselves. I'm just gonna go with 1 value here for the example, but how about something like... with recursive foo (RowNumber, F1, sumF1, OverallAvgF1,

Re: [sqlite] Running sums and averages

2017-11-12 Thread Graham Holden
>>> Is there anything I can do to reduce the time taken? > > < Simon correctly advised > > > Do it in your favourite programming language rather than SQL. > Let me be even more clear : > Memory is cheap and most servers have plenty. > Processors are fast and most servers have

Re: [sqlite] Running sums and averages

2017-11-12 Thread Keith Medcalf
EXPLAIN QUERY PLAN is the first step. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Balaji Ramanathan

Re: [sqlite] Running sums and averages

2017-11-12 Thread Dennis Clarke
Is there anything I can do to reduce the time taken? 123456789+123456789+123456789+123456789+123456789+123456789+123456789+12 > < Simon correctly advised > > Do it in your favourite programming language rather than SQL. Let me be even more clear : Memory is cheap and most servers have

Re: [sqlite] Running sums and averages

2017-11-12 Thread Joseph R. Justice
On Nov 12, 2017 11:06 AM, "Balaji Ramanathan" wrote: Hi, I have a table (mytable) with several numerical fields. Let us call them F1, F2, etc., etc. The table also has a row number field (RowNumber) that I make sure has incremental values from 1 through the

Re: [sqlite] Running sums and averages

2017-11-12 Thread Simon Slavin
On 12 Nov 2017, at 4:05pm, Balaji Ramanathan 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