8 ms·
> Essentially all applications that are performance-sensitive use a stored-procedure interface to run application logic inside the DBMS and avoid the crippling
by taffer 8y ago
> Essentially all applications that are performance-sensitive use a stored-procedure interface to run application logic inside the DBMS and avoid the crippling overhead of back-and-forth communication between the application and the DBMS.
—Micheal Stonebreaker [1]
[1]: https://courses.cs.washington.edu/courses/csep544/10au/resources/p10-stonebraker.pdf https://courses.cs.washington.edu/courses/csep544/10au/resou...
- riku_iki 8y agoAlso stored procedures are convenient for complex data processing, SQL is much more expressive and efficient for selecting, grouping, joining than something like java.