Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The Effect of Set Relation to in SQL?
Message
From
30/07/1997 09:52:17
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
 
 
To
30/07/1997 09:48:10
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00042314
Message ID:
00042321
Views:
37
>>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...
Previous
Reply
Map
View

Click here to load this message in the networking platform