[eluser]ray73864[/eluser]
i suggested to someone a long time ago to use INFILE for doing the import, depending on how many records you have to import, and how complex your import process will end up being, having the DB server do the import instead of PHP will be *much* faster.
each line from the CSV file that i was reading for instance (with over 20,000 records) had to be checked to see if it existed, and if it did, update it, otherwise insert it, lets not even go near the deleting side, and using PHP this was taking several hours, using INFILE however the import took less than 3 secs to do.
my CSV import however was only accessible on the admin side of the website, so it was never a security risk.
