You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Dec 3, 2019. It is now read-only.
Hi, I'm seeing a massive performance degradation with the commit 90e4194 .
I suspect Postres handles with the numeric conversions badly -- but not really sure that is the root cause yet, or how to work around the issue.
Sample code:
object TestPerf {
def main(args: Array[String]): Unit = {
val configuration = URLParser.parse("jdbc:postgresql://someaddress/somedb?user=someuser&password=topsecret")
val connection: Connection = new PostgreSQLConnection(configuration)
Await.result(connection.connect, 50.seconds)
val startTime = LocalDateTime.now()
for (i <- Range(1, 1000)) {
val id = Random.nextInt(3000000)
Await.result(connection.sendPreparedStatement("update companies set name = name where id = ?", Array(id)), 10.seconds)
val elapsed = java.time.Duration.between(startTime, LocalDateTime.now())
println(s"$i : ${elapsed.toMillis / i} average mSec per update")
}
connection.disconnect
}
[info] Running com.example.TestPerf
1 : 1611 average mSec per update
2 : 1463 average mSec per update
3 : 1526 average mSec per update
4 : 1438 average mSec per update
without:
[info] Running com.example.TestPerf
1 : 68 average mSec per update
2 : 67 average mSec per update
3 : 61 average mSec per update