title: Sum and Count queries taking exceptionally long time
body: <p>I am aware that there are other questions on this same topic.  I have read through all of them, and have not found an answer that helps my situation.  Maybe that means there is no solution...</p>
  
  <p>I am using innodb.  I have a table that looks like this:</p>
  
  <pre><code>`feature` varchar(255) primary key 
  `1` int default 0 
  `2` int default 0 
  ...
  `33` int default 0 
  </code></pre>
  
  <p>I need to get the sum of the values in any column, and the count of each column (where the row value is not 0).  </p>
  
  <p>The last query I ran was:</p>
  
  <pre><code>select count(*), sum(`1`) from spec_unigrams_temp where `1` &lt;&gt; 0
  </code></pre>
  
  <p>I have tried many others.  That last query took 450 seconds to run!  </p>
  
  <p>Is there anything I can do to get that time down?</p>
  
  <p>Thanks in advance!</p>