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 http://coding.smashingmagazine.com/2011/03/23/speeding-up-your-websites-database/