Hi there, I'm currently using derby to log values applying in my application. One value consists of a string, a date object and a double value. Not much data. But I want to insert a huge amount of entries.
At the moment inserting 10 000 entries takes about 2 seconds. Now I would like to here your opinion about how to improve performance (if possible). Here the ideas I'm currently using (comment if you want) 1.) I use a table without indexes, primary keys and so on. "create table log(id varchar(50), value double, timestamp date)" 2.) I use the embedded mode 3.) I use a prepared statement "insert into log values (?, ?, ?)" 4.) I disabled auto commit and use addBatch for all 10000 entries. at the end I call executeBatch() and commit() I would like to here your suggestions or comments. Best regards ______________________________________________________________________ XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! Jetzt gratis testen! http://freemail.web.de/home/landingpad/?mc=021130
