|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Wednesday, November 11, 2009 3:18 AM
Points: 21,
Visits: 46
|
|
Dear Friends;
The Problem like I have to Write the sp in Sqlserver 2005 the Sp run around 6min;
Because The Lot of tables and various database to fetch the records;
I want to use Asp.net front End to Run the Problem;
To Throw Error at
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How Can i Over come the Problem;
In Asp.net Configuration To Set sessionTime out in 20min;
In other way to run the sp in with in 3 min;
How it;s possible
Pls help me;
Thanks advance;
A.Faijurrahuman
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Yesterday @ 4:30 PM
Points: 21,860,
Visits: 6,079
|
|
| tune the query to run faster.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 2:06 AM
Points: 1,
Visits: 2
|
|
Hi,
optimize the query use some following steps :
select query from condition joins with (nolock).
declare table variable in your stored procedure if you have any condtions like groupby or where condition.This will reduce the time of your exection.
create non-clustered index for maximum required columns.
use view table with nolock , based on the condition.
put your procedure in .net CLR integration, this will give better performance to you.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 6:25 AM
Points: 1,173,
Visits: 207
|
|
faijurrahuman17 (10/30/2009)
Dear Friends;
In Asp.net Configuration To Set sessionTime out in 20min;
That is the Web Session time and has nothing to do with your database connection.
You have Query Timeout on your Command object and you have connection timeout on your connection object. These needs to be changed.
|
|
|
|
