Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Very Poor Performance of SQL on Local Table
Message
De
12/02/2002 14:59:17
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00618884
Message ID:
00619057
Vues:
20
>Hi Renoir,
>
>Note how long will take to do
SELECT * FROM data\Employee.dbf INTO CURSOR temp NOFILTER
Multiply that time by .7 ( 70% records you extract with your query). That should give you an estimate of the min time your query could take.

Hey Sergey,

Cool. Yeah, that's also kind of the bad news; it's really not going to run much faster. I think I'm going to have to revamp how I handle the data when the form intializes.

Renoir
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform