airhacks.fm podcast with adam bien cover image

Java Persistence: From DB over JDBC to Transactions

airhacks.fm podcast with adam bien

00:00

Using a Pre-Feed Statement in a Database?

Most of the time developers are simply executing one statement and then switching to another. So they might, actually, all of them do that. They don't really prepare the statement. They just execute it, they emulate it on the client's side,. Then just execute the statement and build the syntax tree on the fly. Only when you prepare a statement like Postgres has a threshold of five. It will cache it on the server side and give you the handle so you can reuse it. And it's available for as long as the connection is open. You don't close the physical connection. This is also very important for people to know. Pooling is great because you don't have to

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app