mchopda
asked on
Query Timeout Expired
I have SQL 7.0. When I run a query which takes longer than a minute it gives an error saying query timeout expired. Does anyone know how to increase this time limit of one minute.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to wait with no limit, set the timeout property even to 0 (wait indefinitely), but i agree with simonsabin: are you sure that the query cannot be optimized in some way?
Timeouts are usually set at the client tool (application).
I do not necessary agree with the above 2, some queries just take long...
depends of course if you use them on a user front end or in a report...
so look in the application for the current setting.
I do not necessary agree with the above 2, some queries just take long...
depends of course if you use them on a user front end or in a report...
so look in the application for the current setting.
Ado will is client side.
I only said I question the time. I know there are certain things that take a long time.
I only said I question the time. I know there are certain things that take a long time.
ASKER
The reason the query is taking so long is b'coz i have a temporary table from which data needs to be updated and it has to make sure that it does not duplicate. Also a unique record is made up of 5 fields and hence it is taking so long.