I need a fast script preferably in perl (command line php is ok) that will download an xml file from a url every 10 minutes, parse it and then compare certain fields from the xml data against existing mysql database. Insert any new entries or update existing ones based on a criteria.
This script needs to be optimized to work with existing 400,000 row tables doing matching against the xml data, so you need to know how to optimally design it for speed and performance.
Please do not bid if you have no rating here.
Your success on this project will guarantee ongoing work.