Does it matter whether the primary key is the current active key when doing a tableupdate, or does setting to no active key speed access for a tableupdate.
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?
Précédent
Suivant
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