dgk
|
Posted: 10/24/2003, 7:00 AM |
|
ASP.NET VB SQL2K
I'm need to create pages that require long queries (like 5 minutes). I keep getting timeout exceptions, either SqlExceptions or OleDbExceptions, based on which driver I use. Either way, I can't figure out how to extend the timeouts.
I can't find a place in the CCS GUI or the generated code where I can edit command timeouts. Does anybody know how to do this??
Thanks in advance!
dgk
|
|
|
ryan
|
Posted: 10/25/2003, 1:21 AM |
|
ASP.NET VB SQL2K
First the queries can be optimized if you use stored procedures then you must close recordsets occassionally.
Using CCS you need not to create connection use the CCS connection DBConnectionName.Execute, reuse it it's a class already so it's faster.
Then for extending timeouts, I have to do this when I am accepting file upload only that but you just add this line where the Dim (declarations) are placed
on common.asp or since you are using ASP.NET maybe on the config or somewhere I do not know ASP.NET can still accept ASP right?
Server.ScriptTimeout = [seconds] '120, 400, 1000 ???
|
|
|
|