Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed problems - getting desperate
Message
De
03/03/1999 18:06:05
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, États-Unis
 
 
À
02/03/1999 10:10:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00192832
Message ID:
00193818
Vues:
13
>Hi Elyse.
>
>>I've marked all of my views as NoDataOnLoad in the DataEnvironment but they still take a long time to open. Why would the statement USE MyView NODATA take a long time to execute?
>
>There was a tip in FoxPro Advisor a few issues back on this topic. If I recall, it's due to the way VFP handles SET DELETED when you open a view NODATA. Try SET DELETED OFF before opening the views NODATA, then SET DELETED ON; that seems to improve the time VFP takes to create the empty cursor.
>
>Doug


I don't understand why, but this helped tremendously! Now the views load instantaneously. Thanks!

Elyse
Elyse Pomerantz
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform