title: Parsing and Inserting 10 million records into SQL
body: <p>So I have ~10 million records in an excel file that have to be parsed out in a specific way (I can't just convert to CSV and insert it like that) and inserted into different tables of a mysql database. I've gotten it down from taking all night to taking only a couple hours. However I would like to decrease this even further. Anyone have any tricks or tips that could help me? I'm using Java and JDBC to parse and connect.</p>