title: varchar or text - mysql performance
body: <p>if we have table such:</p>
  
  <pre><code>create table x(
     id int primary key,
     something_else_1 int,
     something_else_2 int,
     something_else_3 int,
  
     char_data text, -- or varchar(1000)
  );
  </code></pre>
  
  <p>this table will be queried on all fields except char_data.</p>
  
  <p>most queries will be similar to:</p>
  
  <pre><code>select id, something_else_1
  from x
  where something_else_2 = 2 and something_else_3 = 5;
  </code></pre>
  
  <p>question is - if we have indexes etc,</p>
  
  <p>what configuration will be better - text or varchar.</p>
  
  <p>Just one final note - </p>
  
  <p>I know I can separate this into two tables, buy separation in this case will be not the best idea, since all fields except the blob's will be something like unique index or similar.</p>