I forgot to ask, how big is that table? Also could you post whole SELECT?
>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
>> SYS(3054,12,"sqlText")
>>ENDIF
>>Select a.* from Customer a Into Cursor curCustomer where ???
>>
>>IF _VFP.StartMode == 0
>> SYS(3054,0)
>> MessageBox(sqlText)
>>ENDIF
>>
>> and see what Messagebox shows.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.