mysql bulk update_mysql – Slick 3.0批量插入或更新(upsert)

有几种方法可以使这段代码更快(每一种方法应该比前面的代码更快，但它逐渐减少了惯用的代码)：

>一次运行您的DBIO事件，而不是在运行下一个之前等待每个事件提交：

val toBeInserted = rows.map { row => TableQuery[FooTable].insertOrUpdate(row) }

val inOneGo = DBIO.sequence(toBeInserted)

val dbioFuture = run(inOneGo)

// Optionally, you can add a `.transactionally`

// and / or `.withPinnedSession` here to pin all of these upserts

// to the same transaction / connection

// which *may* get you a little more speed:

// val dbioFuture = run(inOneGo.transactionally)

val rowsInserted = await(dbioFuture).sum

>下拉到JDBC级别并一次性运行upsert(idea via this answer)：

val SQL = """INSERT INTO table (a,b,c) VALUES (?, ?, ?)

ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b);"""

SimpleDBIO[List[Int]] { session =>

val statement = session.connection.prepareStatement(SQL)

rows.map { row =>

statement.setInt(1, row.a)

statement.setInt(2, row.b)

statement.setInt(3, row.c)

statement.addBatch()

}

statement.executeBatch()

}