title: How much faster is timestamp than datetime column in MySQL?
body: <p>This consists of two questions:</p>
  
  <ol>
  <li><p>Is MySQL's timestamp field really faster than datetime field in "order by" query?</p></li>
  <li><p>If the answer to above question is yes, how much faster it could be? Supposed in a table of 100 million rows and frequently sort a bunch of 100-200k rows based on timestamp field inside MySQL, will the sort time improvement be offseted by converting timestamp to readable string format in outside program?</p></li>
  </ol>