>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
ODBC Remote View returning 1M records? You can start it and go to sleep, next day it will be ready. ODBC is much slower than native VFP engine and if for some reason you want to use it for VFP (front-end)- VFP(back-end) scheme, than you have to overlook whole concept of the app, retrieving reasonably small data subsets to user workstations instead of browsing whole tables.
Edward Pikman
Independent Consultant