>Thanks for the info bill. Actually we were able to speed up the app significantly (access a record went from 25 sec to 6 on a P166) by using views instead of the accessing the table directly. But here's my new question: We are using local views and then accessing them like you said (nodataonload and then define the parameter and then requery()). What is the difference with a remote view? We only use one DBC for the App wich is on a Novell file server.
>
>Thanks Bill & All who contribute
>Shawn Burke
>DRI Management Systems

PMFJI.
Basically, local view might be slow, and remore view against native VFP tables is just unreasonable, much slower besides other things.
Honestly, in case of native tables, one record (and/or small recordset) should be accesed for 6 milliseconds (or less) regardless size of tables. The way is to use SEEK or chain of multiple SEEKs.