Mike Yearwood
Toronto, Ontario, Canada
Hi Greg
>Another trick is to keep index sizes small when your table sizes start to grow. VFP is smart enough not to pull an entire full 2GB table through the network when you only want a record or two. But it does however need to read the entire index file.
IMO VFP reads an entire IDX file when there Rushmore is used and the IDX expression matches a condition. I believe it only reads parts of the CDX. Specifically, I believe it reads the equivalent of an IDX from a CDX. If I have 10 tags in the CDX, but only 1 matches the condition, only 1 tags' worth of index data is read.
Using SEEK (non Rushmore optimized) there is significantly less index data flowing across the wire.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only