Re: [sqlite] Improving performance of GROUP BY

On 26 May 2012, at 6:25pm, Udi Karni wrote: > In any event - breaking the SQL up in 2 is still at least twice as better. I do see huge SQL commands on this list sometimes: great big commands of hundreds of characters which could be done simpler and faster if split into two

Re: [sqlite] Improving performance of GROUP BY

It certainly seems to improve things. I ran multiple tests because over time seems like portions of the data get cached and there is a difference between an initial run and subsequent runs. I almost wish simple table-scans would always go exclusively to disk - I am not sure the caching always

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

I'll point out that all of your problem is addressed by open source whereas an external library only addresses part. You could do whatever you want with open source. I refuse to put things into mission critical without source unless support is also purchased with it. Michael D. Black

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On Fri, May 25, 2012 at 8:08 PM, Jonas Malaco Filho < jonasmalacofi...@gmail.com> wrote: > Just curious, what dev language are you using? > I ~believe~ he's using LiveCode: http://www.runrev.com/products/livecode/livecode-platform-overview/ -- -- -- --Ô¿Ô-- K e V i N