Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large Tables and Filters
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00142005
Message ID:
00142037
Views:
22
>We have a system that tracks shipped packages on the internet. Currently the file that we tracking from has about 750,000 records. I set a filter to "ShpSts != "D" AND Date > (Date() - 14)". After scanning through about 30 - 40 records the machine appears locked up. We are running Windows NT Server 4.0 SP3 on a Pentium 233 with 256 Mb ram. If I wait about 3 or 4 minutes the machine frees up. Is this normal? Any ideas on how to correct?

You need indices in order to Rushmore to work. You could index the table on SHPSTS (though if that field can only take few different values, it could be not worth it) and on DATE. There could be other possibilities, but I should know more about the code (for example, which values can SHPSTS take) before.

HTH!
Previous
Reply
Map
View

Click here to load this message in the networking platform