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 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 run
a test and I will bet many mnay many dollars that processing the sums in
memory is orders of magnitude faster than SQL.


Dennis

ps: if your db is MySQL or Oracle db then the problem is trivial with
     the C  API
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to