I have a rapidly growing, write-heavy PHP/MySql application that inserts new rows at a rate of a dozen or so per second into an INNODB table of several million rows.

I started out using realtime INSERT statements and then moved to PHP's file\_put\_contents to write entries to a file and LOAD DATA INFILE to get the data into the database. Which is the better approach?

Are there any alternatives I should consider? How can I expect the two methods to handle collisions and increased load in the future?

Thanks!