Results 1 to 3 of 3

Thread: Best solution for this to increase the speed of execution

  1. #1
    Junior Member
    Join Date
    May 2007
    Answers
    1

    Best solution for this to increase the speed of execution

    I have three different stored procedures. In every stored procedure I am inserting data.

    eg in Sp1, i am inserting data in Table1
    Above thing is same for other two.

    And for each Sp I am Passing different parameters. And three Sp get executed every time. So it is time consumable. What will be the best solution for this to increase the speed of execution?


  2. #2
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: Best solution for this to increase the speed of execution

    Quote Originally Posted by kawareapeksha View Post
    I have three different stored procedures. In every stored procedure I am inserting data.

    eg in Sp1, i am inserting data in Table1
    Above thing is same for other two.

    And for each Sp I am Passing different parameters. And three Sp get executed every time. So it is time consumable. What will be the best solution for this to increase the speed of execution?

    hi kawarea
    i am really sorry but it was dificult to visualize the problem which you are facing
    please post some more detail then probably it would be easier to visualize and reply ....


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Best solution for this to increase the speed of execution

    call these there procedures with in another procedure and pass all the parameters to the main procedure


  4.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact