The Power of Indexes

I am working on VersionEye.com and in the last days we had some performance issues. I added some new data to the database and to the views. The rendering of the package detail pages tooked sometimes up to 5 seconds. And because the UI is programmed with Ruby on Rails, some people told me: “Yes of course, Ruby is slow, you should use Java!”.

Hell, No! That was not the problem. I just added some indexes to the database, so that they fit perfectly to the queries. And now, it is crazy fast 🙂 Some pages get rendered in less than 80 milli seconds 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s