Re: [sqlite] Eliminate duplicate entries

2007-09-04 Thread Scott Derrick
yes, after reflecting on it that may be the easiest and less processor intensive... Thanks, Scott John Elrick wrote: Scott Derrick wrote: I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all

Re: [sqlite] Eliminate duplicate entries

2007-09-04 Thread Kees Nuyt
On Tue, 04 Sep 2007 09:20:28 -0700, Gerry wrote: >Kees Nuyt wrote: >> On Tue, 04 Sep 2007 07:53:08 -0600, Scott wrote: >> >>> I have an application that is inserting a record every second. There >>> are thousands of periods from a few seconds to hours long where the data >>> in all the

Re: [sqlite] Eliminate duplicate entries

2007-09-04 Thread John Elrick
Scott Derrick wrote: I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all the columns is identical thus causing hundreds of thousands of duplicate rows. Is there a way to set up the INSERT

Re: [sqlite] Eliminate duplicate entries

2007-09-04 Thread Gerry Snyder
Kees Nuyt wrote: On Tue, 04 Sep 2007 07:53:08 -0600, you wrote: I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all the columns is identical thus causing hundreds of thousands of duplicate

Re: [sqlite] Eliminate duplicate entries

2007-09-04 Thread Kees Nuyt
On Tue, 04 Sep 2007 07:53:08 -0600, you wrote: >I have an application that is inserting a record every second. There >are thousands of periods from a few seconds to hours long where the data >in all the columns is identical thus causing hundreds of thousands of >duplicate rows. > >Is there a

[sqlite] Eliminate duplicate entries

2007-09-04 Thread Scott Derrick
I have an application that is inserting a record every second. There are thousands of periods from a few seconds to hours long where the data in all the columns is identical thus causing hundreds of thousands of duplicate rows. Is there a way to set up the INSERT statement to allow the