some time query took little bit long time!!!
-
Hello friends!! I observe that sometimes my queries took 2 0r 3 sec and sometimes it took 1.30 min or 2 mins that might be problem due to some other user access same table or view?? already i optimised my query but still it took sometimes little bit long time! if soem other user access the same table then is there any process to lock the table or waiting option ???? please help me out!!! T.I.A Shashank
-
Hello friends!! I observe that sometimes my queries took 2 0r 3 sec and sometimes it took 1.30 min or 2 mins that might be problem due to some other user access same table or view?? already i optimised my query but still it took sometimes little bit long time! if soem other user access the same table then is there any process to lock the table or waiting option ???? please help me out!!! T.I.A Shashank
if another user opens the table for exclusive use before you do, it will be locked until he closes it. IIRC The default locking scheme depends on the version of access in use, and connection string defaults' Some can be modified by the connection string or connection properties see this[^] for more information Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer