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
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
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