19min chapter

airhacks.fm podcast with adam bien cover image

Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database

airhacks.fm podcast with adam bien

CHAPTER

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

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode