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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement