There are three ways to interact with the database in client / server computing: Play “Twenty Questions” with SQL statements; Move all the data to the client, and then back again; and, Use a stored procedure to move the problem to the server. Of these, using stored procedures is the most efficient and logical choice […]
Shocking Fact: Stored Procedures make OLTP faster. Seriously!
April 11, 2017