Why stored procedures are preferred in cross applications?

Posted onFriday, 25 May 2012bySQL Developer

If we are running set of queries as part of a process, then sending or transmitting all those queries through network will increase the network traffic and it uses more bandwidth. Stored procedures internally encapsulate the entire business logic in a unit. By invoking just stored procedure name will reduce the burden on network. Also, this uses less bandwidth. This is the reason Stored procedures are more preferred in cross applications than independent queries.