Recently, there has been a lot of buzz about NoSQL databases. In fact, there were at least two conferences on the topic in 2009, one on each coast.
You seem to be giving a feeling that using a DBMS native code like a stored procedures can *always* give you better performance than accessing the Db via ODBC/JDBC kind of APIs. This can be true only for cases where the application is fetching a lot of records and ferrying them over the wire to "application server" tier where it applies some business logic to them to finally produce just a small dataset as a result. In such cases sure one could avoid the n/w overhead by doing all the business logic in a stored procedure, but other than such a scenario there's not a significant performance gain in using stored procedures.
The topic itself and the article are interesting, but I really think that 15 Dollar are way too much for just 2 pages.
Displaying all 2 comments