Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Best solution for this to increase the speed of execution

This is a discussion on Best solution for this to increase the speed of execution within the SQL forums, part of the Databases category; 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. ...

Geeks Talk > Databases > SQL Best solution for this to increase the speed of execution

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-13-2007

kawareapeksha Junior Member   Join Date: May 2007 Location: Pune Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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?

Sponsored Links

#2 (permalink)   05-14-2007

aardvax Contributing Member   Join Date: Jan 2007 Location: india Posts: 41 Thanks: 7 Thanked 3 Times in 3 Posts

Re: Best solution for this to increase the speed of execution Quote: Originally Posted by kawareapeksha 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 (permalink)   07-10-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

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

Geeks Talk > Databases > SQL

« Join two tables and apply group by clause | save some text data in SQL »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
plz give me a solution to my doubts..	rajgeo	Oracle	1	05-07-2007 03:57 AM
Audio Converter Plus is a powerful, professional solution designed for converting the	JobHelper	Geeks Lounge	0	01-26-2007 01:21 PM
what is the solution ?	psuresh1982	Brainteasers	4	12-29-2006 09:24 AM
How to increase performance in ejb3.0 while persiting 1GB of data?	pavan.mukkara	Java	0	11-29-2006 12:01 PM
Can you find the solution?	Robert	Brainteasers	1	08-14-2006 05:05 AM

All times are GMT -4. The time now is 01:46 AM.