Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The Effect of Set Relation to in SQL?
Message
De
30/07/1997 09:52:17
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, États-Unis
 
 
À
30/07/1997 09:48:10
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00042314
Message ID:
00042321
Vues:
35
>>Matt,
>>
>>From what I know from the documentation, the less you 'SET' the better the performance. I specifically remember this about ORDER. I also suspect that rushmore exclusively recognizes .CDX, and simply disregards .IDX. In fact, if you want to increase performance, and robustness to a certain extent, I'd advise to changed the .IDX into .CDX tags.
>>
>>HTH,
>>
>>Marc
>
>
>Agreed, and done...to a certain degree. Legacy app. Some optimization was done by adding CDX's, but the old IDX's must be supported or else a major fix is necessary and we're rewriting it in 5.0 anyway (it's a FPD2.5 now)
>
>Thanks for the clarification on the SETs. Perhaps I was confused by the use of IDX's in some of the older apps I've worked on.
>
>Matt

And one clarification... IDX's must be SET if Rushmore is to use them. I have benchmarked this. An average 75% performance improvement was noted when the IDXs were SET first.
Matt McDonnell
...building a better mousetrap with moldy cheese...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform