When to go for stored procedures rather than embedded SQL -


i confused when go stored procedures rather embedded sql in code

when googled out, found out these points

  • they allow modular programming.
  • they can reduce network traffic.
  • they can used security mechanism.

is please tell me how network traffic related ??

they can reduce network traffic returning required data client.

or turn around; design/coding practice can waste network traffic select set of data db, return client , processing there on of dataset. if working on of data set better traffic perspective not send client data not being processed


Comments

Popular posts from this blog

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

java - Why is BlockingQueue.take() not releasing the thread? -

jQuery Ajax Render Fragments OR Whole Page -