Re: Running stored proc on very large database

From: "Vitali Kalinin" <vitkalinin@xxxxxxxxx>
Date: Mon, 31 Mar 2008 11:38:09 +0300

"Larry Killen" <lkillen@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:47f04187@xxxxxxxxxxxxxxxxxxxxxxxxx

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?

Yes it is the simpliest solution. Another option would be to create job on
SQL server and schedule it om immediate execution (see sp_add_job,
sp_add_jobstep, sp_add_jobschedule in BOL).

Thanks

Delphi 2006
MS/SQL 2005

Follow-Ups:
- Re: Running stored proc on very large database
  - From: Larry Killen

References:
- Running stored proc on very large database
  - From: Larry Killen

Prev by Date: Running stored proc on very large database
Next by Date: Re: List availalbe SQL Servers?
Previous by thread: Running stored proc on very large database
Next by thread: Re: Running stored proc on very large database
Index(es):
- Date
- Thread

Relevant Pages

Re: Running stored proc on very large database
... I want to run this from a Delphi app. ... When I fire off the stored proc it ... Should I jst set this to some huge value such as 6000? ...
(borland.public.delphi.database.ado)
Re: Running stored proc on very large database
... I want to run this from a Delphi app. ... When I fire off the stored proc it ... Should I jst set this to some huge value such as 6000? ...
(borland.public.delphi.database.ado)