Implementing set of processes in a stored procedure or through the code?
Posted
by
just_name
on Programmers
See other posts from Programmers
or by just_name
Published on 2013-10-22T14:57:01Z
Indexed on
2013/10/22
16:02 UTC
Read the original article
Hit count: 285
I want to know what's the suitable method to implement the following case (best practice).
If i make a set of processes like this :
1- select data from set of DB tables.
2- loop on the selected result .
3- Make some checks on each iteration .
4- Insert the result in another table .
Implementing the previous steps in a stored procedure
or in a transaction through my code (asp.net)
. ? Concerning the performance , security and reliability issues .
© Programmers or respective owner