>>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
>
>Do you have indexes on the cmrno and actflag fields?

Yes, both CMRNO + ACTFLAG, tried that, no improvement...