Does the table have an index on DELETED() and, if so, what are the proportion of deleted records versus good records?
good luck
>Hi Mike,
>
>Yes I can and I have by introducing a dummy where clause. It optimises and halves the time roughly 2 seconds.
>
>It would appear optimisation is the real issue. I can live with the slight difference, and I am hoping the customer will be happy with that.
>
>Cheers!
>
>Mathias
>>Hi Mathias
>>
>>>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?
>>
>>I just tried a small experiment. Querying a million record table for 10,000 results over the network - only me using the table .591 seconds. With a second user, .7 seconds. Of course my query is fully optimized. Caching will play a role.
>>
>>I would point out, that testing single user access versus multi-user access is not the issue. Most of the time, there will be multi-user access. The issue then is, can you get the query time down from 5 seconds at all?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only