Optimizing the Database

It is no secret that I am using MySQL database on this site just like many other modern websites out there. Unlike many other CMS powered website, the database structure of this site is fairly simple and definitely does not store whole lots of data by default when I perform a clean install of the custom CMS that I created for this particular site for obvious reasons. Understandably, robust CMS that caters wide range of users and supports so many different features which I don't really care much of about.

However, this little blog site of mine is growing and so is the size of the database. Even though it is no where close to the size of any large size, it is growing quite fast and I am happy about the overall progress. Although, I would not mind it to grow even faster while holding the fact that I don't hit any major road block as far as the database is concerned.

Last night I was going over the current structure of the database and figured number of minor issues which I want to change. So, I spent few hours last night and made certain changes to the site which requires changing some of the templates that I am currently using. Specially the catalog section where I store fairly large number of blog sites listing. Currently, these changes are affecting certain pages which I am planning to fix shortly.