How have you done the population of the integer pk field? A stored value in a config table holds the value and is updated when a record is added?

Jason

>Thanks David, I will do that this weekend.
>
>Jason
>
>>Jason,
>>
>>>David, was this a parameterized view or a non-parameterized view?
>>
>>It is a non-parameterized view.
>>
>>In your earlier messages it didn't appear that you are actually subsetting the maintable in the pview. What is the where clause of your view?
>>
>>>The inserting of records seems to be ok. Reasonable time frame. Try deleting all records in the view and do a tableupdate. When I do a tableupdate after marking the records for deletion (purge process) it takes a long time (> 1 minute for 7000 records).
>>
>>with table buffering
>>
>>delete all in view, tableupdate, set talk on = 43 seconds
>>delete all in view, tableupdate, set talk off = 34 seconds
>>delete all in the maintable = 0.511 seconds
>>
>>I really believe that your excessively complex PK is causing most of your problems. Why don't you do your own experimentation using a integer PK on a copy of your table?