Information générale
Titre:
SET EXCLUSIVE OFF - slow TABLEUPDATE
I have a legacy app originally used on one machine in which I only recently put SET EXCLUSIVE ON. TABLEUPDATE and TABLEREVERT are a whole lot slower now, taking as much as several seconds. The main table has only 6500 records, and there is a parameterized view selecting a few records from another table of 5700 records.
I suppose that SHARED use of tables requires some overhead, but this seems excessive.
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