Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore: One more time...
Message
 
To
10/04/2002 13:13:26
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00642985
Message ID:
00643534
Views:
9
Hi Cindy,

Thanks for try to help me! :)

Well...

First of all, when you run the test for the second time VFP has cached the indexes and will re-use that information. To get an accurate evaluation you should close out of FoxPro and in some cases actually turn the machine off.

I've executed this instruction a lot of times, first one, then another... another, then one... :) And all results are the same.

Secondly, when VFP searches a table it reads the index(es) first and then retrieves the records it needs. When there is an index on a field with only a few discrete values (such as gender or yes/no) you are better off NOT having an index on that field. Then VFP will evaluate the other criteria, retrieve records, and make one final pass locally to evaluate the yes/no field.

The field that has a index is Caracter and size 10. It's a primary key in table A and I use this field to relations.

Some suggestion?

Thanks again!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Previous
Reply
Map
View

Click here to load this message in the networking platform