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
>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?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement