title: How to Manage very Large MySql Database
body: <p>I have a copy of the PAF (UK Postcode) database it is currently stored in a MySql Database, and i use it on my site to pre-fill address details, however the Database huge 28,000,000+ records and it is very slow to search.</p>
  
  <p>Any ideas how I could slit the DB to improve performance?</p>
  
  <p>Thanks for the help guys!  </p>