Re: [sqlite] Performance tuning, and other (silly?) SQLite questions.

[Default] On Tue, 20 Nov 2007 09:56:11 +1100, James Steward <[EMAIL PROTECTED]> wrote: >Hi, > >I am new to SQL and SQLite, so please excuse me if I appear thick at >times. > >I have an application that generates data from a moving vehicle. At a >position there may be 10s of pairs of data. Positi

[sqlite] Performance tuning, and other (silly?) SQLite questions.

Hi, I am new to SQL and SQLite, so please excuse me if I appear thick at times. I have an application that generates data from a moving vehicle. At a position there may be 10s of pairs of data. Position is given as an integer, and the data pairs are an integer and a float (real). So I set up a