Better Database Faster Website

by Shigom H
Mismanaging your database can result in serious complications to your website’s performance. In the article “Speeding up your Website’s Database,” author Paul Ferro provides developers with several methods to improve website speed.  He illustrates one technique, of increasing webpage speed, by timing your database queries. By doing this, the user can be able to locate problematic bottlenecks within the page’s code. This is done in PHP by creating a timing object, and using it to see how long each SQL statement takes to run.

Another approach Ferro outlines is to index database tables, in order to make it easier for your website to locate a particular category. Generally, categorical data that will be pulled up on your website should be indexed. According to the author, database columns that refer to indexed data should also be indexed. An additional way of increasing database performance is to optimize your tables. According to the article, this can be done in phpMyAdmin, by inserting “OPTIMIZE TABLE,” followed by the table name.

The article is informative and closely connected to topics discussed in our database class, because it focuses on helping developers create more efficient databases. It also briefly touched upon the different relationships that databases can posses, as discussed in class. For example, database involving many-to-many relationships are more difficult to deal with than other data types.

I found the article to be very interesting because it highlights the impact that a poorly written database can have on your website. In addition to that, it also provides useful tools to help improve your own database.

Tero, P. (n.d.). Speeding Up Your Website’s Database | Smashing Coding. Smashing Coding. Retrieved September 30, 2012, from

4 thoughts on “Better Database Faster Website

  • September 30, 2012 at 11:16 pm

    Hey Shigom! I really enjoyed this. I use MySQL myself for the CMS website I have and I might try looking into these simple improvements so I can speed up my website. The optimize feature reminds me of “defragmenting” on a windows computer – and its so easy!

  • September 30, 2012 at 11:28 pm

    That is a pretty neat trick. I didn’t know database management softwares have the ability to do those sorts of things. But I definitely agree that poorly managed databases can create problems in the future. Thanks for sharing.

  • October 1, 2012 at 12:52 pm

    Good choice of article describing the fundamentals of database and SQL, also how it affects website performance. I’ve bookmarked this article as well. The article gave an example we talked about in class, the traditional order-product relationship, it would be better if you had discuss about it more when mentioning the “many-to-many relationships are more difficult to deal with”.

  • October 1, 2012 at 7:41 pm

    Hi Shigom. Thanks for the article. I found it very useful. Many people tend to not think about the database when troubleshooting speed issues, however, many times you will find noticeable performance increases with the properly optimized database. One thing that I’ve learned in the past in regards to indexing is that indexes are good for retrieval, but slow down insert and update operations, so it’s a good idea to think about what you’re going to index and if you actually need to index it or not.

Comments are closed.