How Stored Procedures make databases FAST

Опубликовано: 15 Октябрь 2024
на канале: Gaurav Sen

18,078

481

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/sys...
Instagram:   / interviewready_
LinkedIn:   / interview-ready
Twitter:   / gkcs_

#Databases #StoredProcedures #QueryOptimization