Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can a USE command execute my code?
Message
De
30/07/2007 16:08:35
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01244678
Message ID:
01244710
Vues:
14
I agree - I would go structural now.
NS has made more work for me.
Back when this was done, computers were slower and any differences in performance may have been much more significant.
Don't know if maybe earlier versions of FoxPro made NS indexes more attractive then -


>
>WHAT?
>How many APPEND's you have in the application?
>If you change APPEND BLANK->REPLACE to INSERT INTO the index will be updated when the INSERT finish its job.
>Even if you didn't use nonstructural compound index you have to REINDEX after the APPEND, so no speed gain.
>If that INDEX is opened again no speed gain because it is reindexed automaticaly.
>If you use structural compound index your life will be much easier.
>No need to care if the index is updated -> it is.
>It will be used for Optimization (I am not sure about if nonstructural compound index could be used for this, because I never used them).
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform