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

hmmmm.... about how many records does this view pull down? perhaps you could try reindexing/packing the table?