title: How can I optimize a MySQL server for queries without joins?
body: <ul>
  <li>All tables in the database have one timestamp column [<code>float</code>]
  followed by an arbitrary amount of parameter columns [<code>integer</code>]
  (usually less than 5, but more than 1), and one value column
  [<code>float</code>].</li>
  <li>All queries are without any joins, and they are based on giving the database a set of parameters, and receiving the timestamp and value columns back. </li>
  <li>The amount of rows are counted in low 10s of millions.</li>
  <li>Small number of users, less than 10.</li>
  <li>More reads than writes, but both can be simultaneous.</li>
  <li>Should meet ACID properties.</li>
  </ul>
  
  <p>Back in the day all MySQL was chosen, but this is a moot point. SQLite is quick and effortless on a computer local basis, but in this example it needs to be a proper server/client database. Up until this point no optimization has taken place, except for indexing.</p>
  
  <p>EDIT:</p>
  
  <p>I didn't mention it properly, but the traffic is not an issue. That is, it's not really an optimization for meeting certain volume criteria, it's an optimization on pure speed.</p>