Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>Table has 35K records and 28M size.
>>"Set filter to &filterexpr" work quit fast.
>>However, filter release "Set filter to" is very slow.
>>What can I do to accelerate it ?
>>Or , maybe, I can use a different command to release filter ?
>>Any remarks will be appreciated
>>
>>Ed
>Do you have a lot of deleted records? If so, and you have "SET DELETED ON" then you need and index tag on DELETED(). Other than that, I can't think of why turning a filter off would be anything but instantaneous.
I tried and it works much better.
Thank You.
Ed.
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