Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database
airhacks.fm podcast with adam bien
00:00
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.
Transcript
Play full episode
