Hi Dodi,

For the test, select just few fields (or one field), not select * See, if you have significant speed improvement.

>Hello,
>
>Why is the first run of a view so slow? (~3 minutes, file has 165K records, size 10.7 MB, cdx 9.6MB; then requeries take only 1-2 seconds; different story if more than one user on the system!)
>
>.EXE is on clients local computer, data on server; Visual FoxPro as file server.
>
>SAMPLE VIEW:
>SELECT * FROM tacust WHERE tacust.cmrno = ?mcmrno AND tacust.actflag = "1"
>(in the form, the user enters a customer number (into the variable mcmrno) then it requeries the view)
>
>CMRNO is already indexed in TACUST file.
>
>I did some research and tried different approaches. Tried using DEL tag on DELETED() but no improvement. I also tried adding ACTFLAG as index (for Rushmore optimization) but it did not help. SYS(3054,1) stated that Rushmore optimization level for table TACUST is none. I don't understand.
>
>We can't switch to SQL server because I can't justify the business case when only five users access the system.
>
>Any help would be greatly appreciated.
>
>TIA
>~Dodi