Mike Yearwood
Toronto, Ontario, Canada
Versions des environnements
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement