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?