
Java Persistence: From DB over JDBC to Transactions
airhacks.fm podcast with adam bien
SQL Server DB2 Supports Statement Caching
statement caching allows you to reuse some segments, some steps which are part of the execution of an SQL string. Some databases for which you pay a lot of money take it a little bit further and allow you to even reuse the execution plan. It's a trade off between memory, you know, and CPU and wasting time of processing stuff. But nowadays, I don't think that memory is an issue because most servers have quite a lot of memory. And just if you configure the statement cache to,. even if it takes five or 10 megabytes, I don’t think that's going to be a problem. When you have 32, 64 gigabytes of. Memory.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.