Mathias
Sounds reasonable. I would recommend that where poss. you use the join conditions in your SQL (e.g. "inner join OtherTable on ...", rather than "where ...". It can speed up your queries by an order of magnitude.
HTH
Terry
>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?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
