Thanks Borislav,

Comes up fully optimised in both cases. Will try it across the network and see if that makes a difference.



>>Hi All,
>>
>>I have had reports and a colleague has confirmed that a query takes significantly longer if the table being queried is open shared so:
>>
>>Select a.* from Customer a Into Cursor curCustomer where ??? && takes 2 seconds when I am the only user in the system
>>
>>The same query takes 5 seconds if the table customer is open by another user.
>>
>>No views involved
>>
>>Any ideas please?
>
>Mathias,
>did you have appropriate indexes that match the WHERE clause so the query can be optimized?
>I can't remeber if the VFP6 has this function but you can try:
>

>IF _VFP.StartMode == 0 && Just in case you forgot to delete following line
>   SYS(3054,12,"sqlText")
>ENDIF
>Select a.* from Customer a Into Cursor curCustomer where ???
>
>IF _VFP.StartMode == 0 && Just in case you forgot to delete following lines
>   SYS(3054,0)
>   MessageBox(sqlText)
>ENDIF
>

> and see what Messagebox shows.