akka-persistence-jdbc icon indicating copy to clipboard operation
akka-persistence-jdbc copied to clipboard

Potential durable state performance improvements

Open johanandren opened this issue 4 years ago • 1 comments

The durable state has a two-step operation when updating the state, first picking up a new global unique seq number and then the actual insert/update (see JdbcDurableStateStore. I think we could, at least for some of the databases, fold that into a single insert/update referencing the sequence number generator.

Could also be worth making that update into a prepared statement rather than an ad hoc statement for each insert/update.

johanandren avatar Sep 17 '21 13:09 johanandren

Sounds like a good improvement.

patriknw avatar Sep 17 '21 14:09 patriknw