title: Building postcode address lookup based on Royal Mail PAF Raw data
body: <p>I am working on custom build software for postcode lookup based on Royal Mail PAF data. Main purpose of that software is to replace Quick Address (Third party software vendor).</p>
  
  <p>I have a few questions</p>
  
  <ol>
  <li><p>How come Quick Address data files including indexes are under 500MB whereas if you look at PAF raw data it's over 2.50GB. What cleanup and compression techniques they have performed on raw data to achieve that. My imported Db size is 2.50GB (sqlite). I have to use some free/open source Db and paid Db is not my option here.</p></li>
  <li><p>There are 28 million records. How can I improve search by organization name or town for example considering it can be performed using "LIKE" statement?</p></li>
  </ol>
  
  <p>Any idea?</p>