Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore with Index Set
Message
From
26/07/1999 06:26:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
26/07/1999 00:35:32
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00243464
Message ID:
00245981
Views:
27
>I tested with two instances of VFP. I opened a table in both apps. SET ORDER TO Name on both. LOCATE FOR UPPER(Name) = "DD". Assume a find on the name Ddaa. Assume the next record is Ddbb, and the next Ddcc. Go to the other instance of the table and change some name to Ddbz. Go back to the original instance and CONTINUE. I expected the result to be Ddbb, then Ddbz, but no, Ddbz was not found with a CONTINUE. However, LOCATE does find a newly changed record, so there the index is re-read. Unless I've erred, CONTINUE won't find records that have been updated or added since the original LOCATE was called. I guess I don't mind, I just didn't know it worked like that.

That was a really good test. So it seems LOCATE builds the bitmap, and CONTINUE just uses it - not updating on the way. Why not, it's just good to know it. If we needed the ever-updating version, we can always LOCATE REST FOR < the same condition again > and it will rebuild the bitmap, running a good chance that only one page of the index in the cache is dirty, and it may actually still be fast enough.

>>Boy, I think they had lots of fun nine or ten years ago while they created Rushmore...

>Yep. By studying the amount of network traffic you can deduce some things, but the more you think you know, the more questions are raised.

And you actually get to admire the guys who made it. After - how many was it, actually? - some 8 years with Rushmore, I still haven't got into all of its tricks. I hope this doesn't create yet another club, like "Seekers for the Holy Grail of Rushmore Secrets" or anything of the kind.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform