是clojure.jdbc / insert！以批处理模式还是一个接一个地完成？ [英] is clojure.jdbc/insert! done in batch mode or one by one?

问题描述

在我使用clojure.jdbc / insert之后！要插入一些数据，它会打印很多 1，所以我想知道插入是在具有更好性能的批处理模式下完成还是在缓慢的情况下逐一完成。我们最好让它像Java jdbc批处理插入程序一样运行。

After I use clojure.jdbc/insert! to insert some data, it printed many "1", so I am wondering whether the insert is done in batch mode which has better performance or done one by one which is slow. We'd better to have it run like java jdbc batch insert.

clojurewerkz.testcom.core=> (time (apply (partial j/insert! postgres-db  'test_clojure [:a :b :c :d :e])   (map #(process-row % constraints) (repeat 10000 row))))
"Elapsed time: 540.111482 msecs"
(1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 

推荐答案

clojure.jdbc / insert！最终调用

clojure.jdbc/insert! eventually calls

(apply db-do-prepared db transaction? (first stmts) (rest stmts))

调用 db-do-execute-prepared-statement ，因此看来您的答案是肯定的！它分批完成。

which calls db-do-execute-prepared-statement so it appears your answer is yes! it does them in batches.

这篇关于是clojure.jdbc / insert！以批处理模式还是一个接一个地完成？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！