How Stored Procedures make databases FAST

Video Description

Stored Procedures are functions which can run on a database. Here, we discuss how stored procedures work, when and why they should be used, and the potential drawbacks of this approach. We illustrate these points with a real-world example: a war story! 00:00 What are stored procedures? 00:40 Where and how do they run? 01:25 Real-world example 02:30 Request-Response Flow 03:20 First Suggestion - BiDirectional BFS 04:14 Cache results 05:30 Debugging 06:02 The Problem 07:08 Solution - Stored Procedures 08:03 Benefits of Stored Procedures 09:59 Drawbacks of Stored Procedures 12:00 Thank you! System Design Course at InterviewReady: https://interviewready.io/ You can follow me on: Github: https://github.com/InterviewReady/system-design-resources Instagram: https://www.instagram.com/interviewready_/ LinkedIn: https://www.linkedin.com/company/interview-ready/ Twitter: https://twitter.com/gkcs_ #Databases #StoredProcedures #QueryOptimization