Recently, I've been building a PHP script to import an XML file every 24 hours into a MySQL database using a CRON job. This is so we can keep the database on one of our client's websites automatically synchronized with the database in their office.

The problem: Their database contains somewhere between 150,000 and 250,000 records!