Re: any way to "ignore" a value in an INSERT/UPDATE query?

[michael cook]

Rick,

I'll give that a try. Hopefully doing 3 queries won't add significant overhead as the tables are quite large.

As for values being "burned" - I'm not sure I know what you mean by the term - but I haven't seen incorrect values inserted or updated. The PKey is not an AI column though. In fact it's really a unique compound index made up of an unsigned smallint ('y') and a datetime column ('z').

There are two separate tables in question. At this moment in time, one has 89,988,824 rows, where 'y' has roughly 1060 distinct values, and 'z' represents every hour from March 2003 through present

The other table contains 54,368,318 rows, where 'y' has roughly 504 distinct values and 'z' is hourly values from Nov 1999 through present

together, 'y' and 'z' must be unique.