Artwork

内容由Connor McDonald提供。所有播客内容(包括剧集、图形和播客描述)均由 Connor McDonald 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal
Player FM -播客应用
使用Player FM应用程序离线!

Back to basics: SQL Parsing - the silent database killer

27:12
 
分享
 

Manage episode 335905562 series 3376484
内容由Connor McDonald提供。所有播客内容(包括剧集、图形和播客描述)均由 Connor McDonald 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

Parsing is the act of preparing to execute a SQL statement on your database. It would seem to be a necessary activity - after all, that is what databases are designed to do - execute SQL. But the topic of parsing requires a more nuanced look, because a high transaction frequency database typically succeeds or fails based the amount of SQL parsing it does.

In this episode, I'll take you on a trip down memory lane on how slow servers used to be "Get Out Of Jail Free" card for IT practitioners, but how hardware advancements have shifted the responsibility for successful applications squarely back on the shoulders of developers. The way you handle parsing on the Oracle database could open the door to the incredible firepower of modern servers...or leave you scratching your head wondering why your CPUs are running hot but no work is getting done.

And believe it or not...if you have used a public restroom, you are well on the way to understanding how parsing relates to building scalable applications :-)

If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.

  continue reading

41集单集

Artwork
icon分享
 
Manage episode 335905562 series 3376484
内容由Connor McDonald提供。所有播客内容(包括剧集、图形和播客描述)均由 Connor McDonald 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

Parsing is the act of preparing to execute a SQL statement on your database. It would seem to be a necessary activity - after all, that is what databases are designed to do - execute SQL. But the topic of parsing requires a more nuanced look, because a high transaction frequency database typically succeeds or fails based the amount of SQL parsing it does.

In this episode, I'll take you on a trip down memory lane on how slow servers used to be "Get Out Of Jail Free" card for IT practitioners, but how hardware advancements have shifted the responsibility for successful applications squarely back on the shoulders of developers. The way you handle parsing on the Oracle database could open the door to the incredible firepower of modern servers...or leave you scratching your head wondering why your CPUs are running hot but no work is getting done.

And believe it or not...if you have used a public restroom, you are well on the way to understanding how parsing relates to building scalable applications :-)

If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.

  continue reading

41集单集

所有剧集

×
 
Loading …

欢迎使用Player FM

Player FM正在网上搜索高质量的播客,以便您现在享受。它是最好的播客应用程序,适用于安卓、iPhone和网络。注册以跨设备同步订阅。

 

快速参考指南

边探索边听这个节目
播放