Optimizing Web Application Databases

User feedback regarding a CMS web application was that the certain areas of the site were running slow. There could be many reasons for this like the usual suspects of a slow internet connection, poorly optimized images and stylesheets, and large page sizes. In this case there was a large amount of data coming from a couple tables in the database and were combined together to render the page. This was slowing the page load time down as the MySQL database was combining this data. This is where a simple optimization technique called indexing can help. Read more

Backup Your Application Databases

One of things I constantly stress is backup.  When writing web applications we are often focused on the results we want from the application that we can easily forget the underlying infrastructure including the database.  Your beautiful Ruby-on-Rails app is only as good as long as the underlying database structure is alive.  Keep it alive with good database backup.
Read more