search

The-Apiary / buzz

A podcast client with functionality inspired by Rdio
0 stars 2 forks source link

Add indexes to often queried columns. #20

Closed everett1992 closed 10 years ago

everett1992 commented 10 years ago

If the values of a column are being queried often that column should have an index. If a set of values are queried as a set an index should be made for that set of columns.

everett1992 commented 10 years ago

I've added indexes to columns and combinations of columns I noticed were queried against often. It seemed to decrease the average response time by about 10%