How do I decrease execution time in Ms SQL Query procedure

Discussion in 'Databases' started by rmBashar, Jan 20, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. rmBashar

    rmBashar

    Hello every body,
    Can you tell me how can i decrees execution time in my SQL store procedure?

    Please advice me.

    Thanks
    RM Bashar:)
     
    rmBashar, Jan 20, 2012
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    SQL do not limit the execution time. are you having problem w/ your application timing out? if so, try increase the SQL command timeout and execution timeout.
     
    Bruce, Jan 20, 2012
    #2
  3. rmBashar

    rmBashar

    Dear Bruce,

    Thanks to replay.
    Have any idea how to decrease execution time in My SQL Store procedure ?
    Thanks
    -RM Bashar
     
    rmBashar, Jan 21, 2012
    #3
  4. CrystalCMS

    CrystalCMS Joe

    What does your stored procedure do? I can't advise how you might improve it's performance unless I know what it does.
     
    CrystalCMS, Jan 21, 2012
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page