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.
If you are familiar with full text searching in MySQL, you will be surprised to know that MySQL doesn't index words containing 3 or less characters by default. Searching such [...]