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