A new client has just sent me a DB in Microsoft Access format, that needs to be published as a web application.

I must confess I haven't used Access in some years, and it wasn't even installed on my current machines.  The DB was 250MB in size, so I was anticipating that it would take up a fair bit of space once I exported it as CSV and imported it into MySQL.  I'd forgotten just how incredibly inefficient Access is at storing data though.  50,000 slow and clunky records compressed to a lean 8.5MB once they were rehomed in the DB Spa Clinic that is MySQL!

Written by Celerity Design, on March 13, 2008

Write a comment

  • Required fields are marked with *.

If you have trouble reading the code, click on the code itself to generate a new random code.
Security Code: