Hi dodi,

Just as an experiment. Just make the DBC, DCX and DCT containing the view read only and try the same excersize. Does it improve the situation. If so, there is a problem in loading the view defenition.

Walter,


>
>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