Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter is REALLY Slow!
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01225715
Message ID:
01225723
Views:
27
Then don't use filter. Collect records into cursor, and index tag is advisable anyway.

>I understand but part of the problem is that I also have the user select which order he wants to see the data in and there are many ways in which date is not used.
>
>>You should have index tag on VAL(LEFT(CERTS.cDate,4))
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform