Running stored proc on very large database
- From: "Larry Killen" <lkillen@xxxxxxxxxxx>
- Date: Sun, 30 Mar 2008 21:44:40 -0400
I process 30 days of data daily. To do so I run a stored procedure. On
average, it takes about 6 to 7 minutes to run.
I want to run this from a Delphi app. When I fire off the stored proc it
times out. The default command is set to 30 seconds.
Should I jst set this to some huge value such as 6000?
Thanks
Delphi 2006
MS/SQL 2005
.
- Follow-Ups:
- Re: Running stored proc on very large database
- From: Vitali Kalinin
- Re: Running stored proc on very large database
- Prev by Date: ADO/MSSQL and Connect-Permission problem
- Next by Date: Re: Running stored proc on very large database
- Previous by thread: ADO/MSSQL and Connect-Permission problem
- Next by thread: Re: Running stored proc on very large database
- Index(es):