gudii9
asked on
stored procedure call connect times
one registerPhone flow goes through 30 stored procedures. Each stored proc connecting database individually and taking 100 milli seconds to connect.
so 30 multipled by 100 total 3000 milli seconds wasted due to this.
can i make all 30 stored procedures into one call so that only one database connection happens for 100 milli seconds
Like to save those 3000 milli seconds when i can do only with 100 milli seconds
Please advise
so 30 multipled by 100 total 3000 milli seconds wasted due to this.
can i make all 30 stored procedures into one call so that only one database connection happens for 100 milli seconds
Like to save those 3000 milli seconds when i can do only with 100 milli seconds
Please advise
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
please advise