Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Issues in taking IDX to CDX
Message
De
23/06/2014 08:40:13
 
 
À
23/06/2014 05:50:15
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
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 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01602158
Message ID:
01602220
Vues:
55
>>I don't what kind of impact this could have in your case, however one aspect that I consider important (and sometimes still take advantage of) is that creating an IDX file does not require exclusive use of the dbf, as opposed to creating CDX tags that does require the dbf to be opened exclusive.
>
>That's for structural cdx only. A separate cdx can be created at will. And there's a good chance that the app to convert may contain a lot of such ad hoc indexes - that was our main tool before FP had internal SQL engine.

Yes, it does create lots of ad hoc indexes for reporting (though it fails to delete them afterward). Since I'm moving reports toward queries (as well as allowing the user to select multiple filter criteria rather than a single criterion), most of those will simply go away.

Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform