Helping ordinary people create extraordinary websites!

Using MySQL Functions for More Efficient Web Applications

By Katharine Osborne
2009-08-11

Introduction

There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database. However, keeping the calculation in SQL means that the functionality is portable, and often means that less data needs to be retrieved from the database. Why not give yourself a choice and add MySQL functions and calculations to your coding arsenal?

Here are five ways to get more power out of your MySQL SELECT statements.





Tutorial pages:
 3 Votes

You might also want to check these out:


Leave a Comment on "Using MySQL Functions for More Efficient Web Applications"
You must be logged in to post a comment.

Link to This Tutorial Page!


GET OUR NEWSLETTERS