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