How SQL shows us where to program faster

bridgwatera | 2 Comments
| More

In his Nine Reasons Developers Should Learn SQL piece from a couple of years back, Jeremiah Peschka highlighted why SQL is such as great standard.

For those that need a refresher, SQL (Structured Query Language) is probably best described as an interactive programming language for getting information to and from a database.

Before we look to the point of developer insight here, let us also remind ourselves that many database products support SQL with proprietary extensions to the standard SQL language.

So how can SQL as a route to database management help applications work faster?

Peschka reminds us that, in this day and age, there are "only a few places" to implement performance gains in an application:

• the presentation layer,
• the application layer and,
• the storage layer.

So then, why is SQL database knowledge so important for developers?

... and why should developers learn SQL as a route to greater performance gains in their application?

"Let's face it, your code is already well written and well tuned; getting any performance gains there is going to be like getting blood from a stone. The database, on the other hand, is an easy place to make a few simple changes (add an index, change a query slightly) and see tremendous performance improvements," writes Peschka.

He continues, "Having spent a considerable portion of my career as an application developer staring at a profiler, I can attest to this. It's possible to pry performance improvements out of application code, but modern frameworks and toolkits are typically so well-written that the database is usually a better place (read as easier place) to find low hanging fruit for performance improvements."

You can read Peschka's whole piece at the link above to gain wider insight on SQL for developers.

2 Comments

An interesting article, but why are so many people clambering for NOSQL products? Unless real time data is needed (air traffic control etc) there is only disadvantage with SQL, much slower to program and far more expensive per hour as it is so complex.

I would like to see a balancing article along the lines I have written.

Leave a comment

Subscribe to blog feed

About this Entry

This page contains a single entry by Adrian Bridgwater published on January 28, 2014 8:18 AM.

How do we oil the dirty mechanics of cloud application integration? was the previous entry in this blog.

Application beauty is not skin deep is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.