Re: Running stored proc on very large database

From: "Larry Killen" <lkillen@xxxxxxxxxxx>
Date: Mon, 31 Mar 2008 08:46:18 -0400

Thanks,
That works.

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:47f0a2f1@xxxxxxxxxxxxxxxxxxxxxxxxx

"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

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

Prev by Date: Re: List availalbe SQL Servers?
Next by Date: Re: ADO and multiple connection component
Previous 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)