>Hello FoxProgrammers,
>
>I am working with large datasets, over 1000000 records. They are located in FoxPro 2.6 tables on Netware servers and used by 30 people.
>Now I am porting to VFP 5.0 and I thought it would be faster through the use of SQL, remote views, fetching and so on. My plan was to build a select statement that could change interactively on user input (in 7 textboxes). Now I have some problems: it takes several minutes for any more-than-one-criterium search. I have indexes on all 7 criteria. I use remote views through an ODBC connection. The table is 350 Meg.
>What is the best way to upgrade? Using the good old SEEK statement?
>
>Thanks,
>
>Bas

Are you using a "GROUP BY" clause (bad for optimization)? Are your parameters something like FieldName="Value" ? If so, optimization is usually full. Equations like UPPER(FIELDNAME) = "VALUE" takes away from rushmore. Any kind of function on the left side of equation "kills" optimization unless the function is "indexable." Play with the SQL statement your form generates using the SYS(3054, 1) function (see VFP Help for explanation on its use).