>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 really don't want to use SET FILTER on a cursor this size. Even if your filter expression is optimized, it can be quite slow. Look into using a parameterized view to narrow down the number of records you are looking at.
Erik Moore
Clientelligence