search

ydb-platform / tpcc

TPC-C for YDB
Other
10 stars 3 forks source link

Get rid of prepareStatement overhead #18

Open eivanov89 opened 6 months ago

eivanov89 commented 6 months ago

In a multistep transaction we send prepare transaction requests multiple times (obtaining a session each time, which can be blocking).

Alex, you told you know, how to avoid this stuff. Please, have a look again.

alex268 commented 6 months ago

We already added a support of caching of prepared queries to JDBC Driver so there is no overhead for requests except for first

eivanov89 commented 6 months ago

We already added a support of caching of prepared queries to https://github.com/ydb-platform/ydb-jdbc-driver/pull/37 so there is no overhead for requests except for first

So, do we need just to update JDBC driver (as planned)?

alex268 commented 6 months ago

Yes, this issue will be fixed after updating to new version of JDBC driver