Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Every successive SQL select takes longer
Message
De
31/05/1999 06:05:45
 
 
À
30/05/1999 12:35:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00224342
Message ID:
00224620
Vues:
17
>Peter,
>

>That said, SP3 is the first to have *specific* VFP fixes, and there are tons of them. The summary lists:
>Q191172: Performance degradation with Repeated SQL SELECTs

Sounds like my baby!


>Q197510: Poor performance with Forms Cantaining Many Objects

They're working on this, good.



>Finally, I'm not so sure that a CLOSE DATA ALL is the same as a CLOSE ALL.
>
>Good luck,
>
>Jim N


It occured to me after I posted that I was making that assumption. I should check to make sure. I did check for open files with a SET after the CLOSE DATA ALL and there were none.

Peter
Peter Robinson ** Rodes Design ** Virginia
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform