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 realworld example: a war story!
00:00 What are stored procedures?
00:40 Where and how do they run?
01:25 Realworld example
02:30 RequestResponse 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/sys...
Instagram: / interviewready_
LinkedIn: / interviewready
Twitter: / gkcs_
#Databases #StoredProcedures #QueryOptimization