40 ms·
Plprofiler – A Handy Tool for Profiling PL/pgSQL Code
- psim1 8y agoOriginal article title is "plprofiler – Getting a Handy Tool for Profiling Your PL/pgSQL Code." What is the implication behind the title used here, "If you still write stored procedures in a Database, you may need a profiler"?
- mlthoughts2018 8y agoA misguided attempt to play off the “You might be a redneck” joke pattern popularized years ago by Jeff Foxworthy?
- eikenberry 8y agoMaybe 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.
- dang 8y agoWe reverted the title. Submitted title was "If you still write stored procedures in a Database, you may need a profiler", which broke the site guidelines. Submitters: accounts that editorialize titles eventually lose submission privileges, so please remember that the guidelines ask you to "use the original title, unless it is misleading or linkbait; don't editorialize". https://news.ycombinator.com/newsguidelines.html https://news.ycombinator.com/newsguidelines.html