title: SQLite storage class And retrieval efficiency
body: <p>Say I have one table, which is a reference table (the table is only been consulted, not update). </p>
  
  <p>for example, the table schema :</p>
  
  <pre><code>CREATE TABLE countries(
                 zip_code INTEGER PRIMARY KEY,
                 name TEXT)
  </code></pre>
  
  <p>I want to improve the retrieval speed of data. Now, I'm using <code>index</code> on the <code>name</code>column, but I want to go further...</p>
  
  <p>Change the table schema:</p>
  
  <pre><code>CREATE TABLE countries(
                     zip_code INT PRIMARY KEY,
                     name CHAR(200))
  </code></pre>
  
  <p>remarque that I've modified the data type of the columns in order to specify a <strong>fixed size for each column, hence a fixed size for the entire row</strong>.</p>
  
  <p>Is it a correct assumption ? Thinking that <strong>fixed size rows</strong> are retrievable more quickly than dynamic size rows <strong>in SQLite DBMS</strong>. </p>
  
  <p>I'm inspiring from other DBMS (MySQL) which retrieve <strong>static size rows</strong> more quickly than dynamic size rows</p>