Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>On the screen I have a optiongroup that will set a filter for the different area.
>> when I try to refresh the grid it just takes forever. Is this because it has to navigate thru the table or what. Any suggestions.
>Milt, do you have an index on your region field?
If yes, and it's still slow it's probably because you're looking for so few records out of so many.
We have a program that gathers sales out of a leads table. The "working..." display only updates every 100 sales. It feels like forever trying to find the 95 sales out of 50,000 leads. (the routine looks at every record before updating the display - and since it's a proprietary system there's nothing we can do to fix the horrible performance)
Since you only have 3 values, could you make 3 index?
Index on Region="WDC" tag ndxWDC, Index on Region="SFB" tag ndxSFB,
Index on Region<>"WDC" and Region<>"SFB" tag ndxOthers
My thought is that the setting the index would be faster than applying a filter, but i'm not sure if this is a UT-approved method.
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