Hi, I'm using phoenix in java web-application. App does upsert or select by primary key.
What is the right pattern to do it?
- I create new connection for each request
- prepare and execute statement
- close stmt
- close connection
Does phoenix caches connections internally? What is the right way to batch upserts in current case?