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
; 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?
>
;
-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
>>> 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
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
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
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
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
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
9 matches
Mail list logo