About 50K records
Here the actual sql:

Select st_ref as Code, st_desc as Desc Order by 1 From stockname Into Cursor tmpProduct


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