Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database
airhacks.fm podcast with adam bien
Optimizing Database Connections: Parsing and Performance
This chapter explores the intricacies of database connection handling, emphasizing the distinction between hard and soft parsing and their performance implications. It discusses connection pooling, particularly in the context of PHP and Oracle databases, and highlights modern approaches like AWS Lambda and RDS Proxy. Additionally, the chapter covers stored procedures and cloud function integration, showcasing how these techniques can enhance efficiency and simplify interactions in contemporary architectures.
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.
