General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only