Batch insert performance

29 views
Skip to first unread message

Thomas Quealy

unread,
Mar 2, 2018, 2:11:09 PM3/2/18
to Squeryl
I am looking into an app that uses squeryl due to some performance concerns. I see that it is taking 2.5 minutes to insert ~300k rows. This seems very slow. Using my own raw JDBC code I can do the same thing in 12 seconds. One thing I noticed is of in my own raw code if in leave auto commit set to true I get very similar performance to what I am seeing in squeryl.

Anyone have any clues where to go on this?
Reply all
Reply to author
Forward
0 new messages