Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL SELECT RUNS SLOW FIRST TIME EXECUTED
Message
De
16/10/2000 17:57:13
 
 
À
16/10/2000 17:15:12
Gene Maddox
Silver Creek Technologies
Johnson City, Tennessie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00430042
Message ID:
00430062
Vues:
9
It could be that the first time the application is reading un-cached data. After...it is reading cached data.

>I have an application that uses several 50k to 450k record tables and there are many different SQL Select statements. When these SQL Select statements are executed the very first time, it takes up to 4 times as long as it does every time after that. Any suggestions???
Thanks,
Dan Jurden
djurden@outlook.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform