CW Developer Network

Jan 28 2014   8:18AM GMT

How SQL shows us where to program faster

Adrian Bridgwater Adrian Bridgwater Profile: Adrian Bridgwater

Tags:
Database
SQL

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 on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Nigel Boyle
    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.
    0 pointsBadges:
    report
  • Adrian Bridgwater
    Nigel -- get in touch and tell us more. Adrian
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: