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
; -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Balaji Ramanathan Sent: Sunday, November 12, 2017 11:06 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Running sums and averages Hi, I have a table (mytable) with several

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
amanathan >Sent: Sunday, 12 November, 2017 09:06 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Running sums and averages > >Hi, > >I have a table (mytable) with several numerical fields. Let us >call >them F1, F2, etc., etc. The table also has a row nu

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

[sqlite] Running sums and averages

2017-11-12 Thread Balaji Ramanathan
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 number of rows in the table. In addition to printing out the values of F1 through