4 ms·
Maybe they are of the opinion that stored procedures are anachronistic and rarely used anymore?
by eikenberry 8y ago
Maybe they are of the opinion that stored procedures are anachronistic and rarely used anymore?
- 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.