doubt regarding the usage of procedure #722
Pavan-Rajesh
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am running multiple sql statements based on some conditions
query1 ----> selecting workers from the database
query 2 ---> selecting owners from the database
checking if there are any owners in the using the javascript
next
if there is any owner
query3-----> assign the woker to the owner
else insert worker into the workers table
query4---->insert into the workers table
I am having the doubt that if we query these all grouped into a procedures (that means writing all the conditions in the sql) in sql will the performance of my application will increase?
Beta Was this translation helpful? Give feedback.
All reactions