General information
Title:
Large Tables and Filters
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?
Next
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