title: float vs smallint vs decimal in mysql
body: <p>Now I have a table with impressions, clicks and ctr.</p>
  
  <p>I was wondering if I should use tinyint(1) and store ctr which has a range from 1-250 </p>
  
  <p>or should I store it as a float which has more precision. or maybe decimal.</p>
  
  <p>For statistics I would be calculating the ctr using clicks/impressions, so getting a precise value is not a problem.</p>
  
  <p>But for performance what would be the best way to store it.</p>