title: Composite Primary Key performance drawback in MySQL
body: <p>We have a table with a composite Primary key consisting of three fields (and it is in MySQL 5.1). There are near 200 inserts and 200 selects per second on this table, and the size of the table is around 1 million rows and it is increasing. </p>
  
  <p>My question is: does the "Composite Primary Key" decrease the performance of the Inserts and Selects on this table? </p>
  
  <p>Should I be using a simple Auto-Increasing INT ID field instead of a Composite Primary Key? (I think the answer is very much related to the way MySQL handles the Indexes on multiple columns)</p>