Communications of the ACM,
Vol. 53 No. 4, Pages 10-11
10.1145/1721654.1721659
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.
The full text of this article is premium content
2 Comments
Anonymous
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.
Regards!
Ralf Sattler
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
Log in to Read the Full Article
Purchase the Article
Log in
Create a Web Account
If you are an ACM member, Communications subscriber, Digital Library subscriber, or use your institution's subscription, please set up a web account to access premium content and site
features. If you are a SIG member or member of the general public, you may set up a web account to comment on free articles and sign up for email alerts.
Anonymous
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.
Regards!