Get Query execution time[Answered] RSS

• • Reply
  dotnet16

  Member

  18 Points

  135 Posts

  Get Query execution time

  Sep 02, 2010 07:17 AM|dotnet16|LINK

  I need to find out the query execution time from the front end .Where should I insert the code for that.Please help..

  I am using the bleow query:

  OracleConnection con = new OracleConnection(ConnStr);

  con.Open();

   OracleCommand cmd = new OracleCommand("Stored_Proc",con);

  cmd.CommandType = CommandType.StoredProcedure;

  cmd.Parameters.Add();

  ....................

  ................

  OracleDataAdapter

  oda = new OracleDataAdapter

  (cmd);

   

• • Reply
  ketan_al

  Contributor

  4790 Points

  1211 Posts

  Re: Get Query execution time

  Sep 02, 2010 07:32 AM|ketan_al|LINK

  Hi,

  Please refer following

  http://forums.asp.net/p/1203581/2183313.aspx

  hope this helps
  

  Ketan Lohar
  http://www.ketscode.com
  
  MCP, MCTS,MCPD (Microsoft Azure Developer)
  
  Please mark as answer if it helps
• • Reply
  dotnet16

  Member

  18 Points

  135 Posts

  Re: Get Query execution time

  Sep 02, 2010 07:45 AM|dotnet16|LINK

  Got idea.

  But where do I insert the time check.i.e.,exactly at what line?

  Do I need to include it before the connection object initialization or is that before  initilaizing dataadapter

  OracleDataAdapter

  oda = new OracleDataAdapter(cmd);