Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Large Tables and Filters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00142005
Message ID:
00142037
Vues:
23
>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!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform