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 statement to allow the insertion
of a new row of data, where one or more columns has data != to the
previous insertion, but ignore or skip the insertion of a duplicate row?
Is there some reason you couldn't simply do that in code? Cache the
last inserted row, compare before calling insert and skip if it is
identical?
John
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------