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?
>
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,
>>> 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
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
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
8 matches
Mail list logo