RE: SQL Server timeout
- From: "VN" <VN@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 14:23:05 -0700
Can you create a table in tempdb and put everything there? Requery later?
"Sachi" wrote:
> Hi,
> There is a intresting question.
> A stored procedure takes about 7 minutes to run, it process over 50
> million records but aggregates them into about a 400 records.
> When I am trying to invoke it from my aspx app it is sure going to fail.
> Is there any good soultion to this problem?
>
>
> Sachi
.
- References:
- SQL Server timeout
- From: Sachi
- SQL Server timeout
- Prev by Date: RE: Data Link dialog always returns Connect Time value of 15
- Next by Date: RE: Right click Views node in Server Explorer to Add new View
- Previous by thread: SQL Server timeout
- Next by thread: Right click Views node in Server Explorer to Add new View
- Index(es):