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