Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REINDEX - Without EXCLUSIVE.
Message
From
19/05/2004 09:38:40
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00841224
Message ID:
00905253
Views:
28
Houston,

If you are willing to provide it, I will test it and, if successful, check into testing it in production. We have beta sites for our new versions that may be appropriate and we are putting out a new version of our app at beta sites next week (our beta sites are all local to us so we can be onsite quickly if necessary)....

Tracy

>Something we all should be doing on a regular basis is rebuilding Indexes. Simply relying on the REINDEX command is not necessarily the best route to go. Ideally the Tags should be dropped and recreated from scratch. This is a problem if the Tables are referenced by a DBC and have persistent relationships / Primary Keys / Candidate Keys or if you have systems that really do run 24 by 7.
>
>For a couple of months now some of the FoxPro community’s leading luminaries have had access to a utility I created that facilitates SHARED mode recreation of Indexes. I am now looking to find additional people to put this into their production systems and who are also willing to provide testimonials.
>
>Feel free to reply either to this post or using a private message.
>
>Regards to all,
>Houston.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform