[This topic is migrated from our old forums. The original author name has been removed]
Hi!
I have experienced that huge CSV file (with several millions rows) import takes too long.
I found that DBVis inserts row by row which not the best way filling table with huge amount of data.
What about the batch execution of insert statements via PreparedStatemnt.addBatch() and PreparedStatement.executeBatch() (e.g. 1000 insert statement execution at once)?
It could provide better performance I guess not only for importing of huge amount rows but for slow DB connection where less amount of data is affected.
I would suggest to extend CSV import with batch execution.
Br,
Zsolt
1 Comment
Roger Bjärevall
said
almost 12 years ago
[This reply is migrated from our old forums.]
Re: IMPORT CSV file faster way
Zsolt,
We have a ticket for improving import performance. I'll add your vote for it.
Regards
Roger
anonymous