Hi Philip
I'm just now getting into using the VFP 9 CursorAdapters on a form using the ADO data connection to an SQL 2K Server DB. Question I have... is there anyway to put indexes on the CursorAdapter in order to use the seek() function rather than LOCATE ? Or, is there a better way to SEEK using a method on the Adapter ??? Also, is there a more efficient way to open the adapters? It's taking so long to open, I have them set to retrieve all records because I need all the records to produce some temp tables that are in Grids on the screen... I saw the option to only retrieve 100 or so records and Fetch as needed... how can I make sure I pull all the records from the CursorAdapter when I perform an SQL-Select from the cursor tied to the adapter into a temp file??
I wrote about when not to use Rushmore for FPA back in 98. A LOCATE NOOPTIMIZE can be faster than indexing the file and doing a seek. Indexing the file needs to read the records to produce a set of index keys in a first pass. A second pass sorts the keys. The seek then uses the index to do a binary search. While extremely fast, the combination of all of this can be slower than just doing the locate. NOOPTIMIZE prevents the Rushmore engine from examining the indexes at all. It goes straight to searching. By the way, don't pull lots of records and the difference between the seek and the locate will be negligible. HTH _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
