| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | magawake(at)gmail(dot)com, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Reason(s) not to use a stored procedure |
| Date: | 2008-01-22 15:33:21 |
| Message-ID: | 36e682920801220733g392a49aqf952698fdb1ef288@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> I was in an academic meeting where a professor was
> preaching the reasons why not to use a stored procedure.
> He advised to always use SQL instead of a procedural
> language. Can someone please shed some light on this?
Those who can't do, teach?
Honestly... SQL can't do business logic, auditing, etc. Similarly, by
keeping the data local, stored procedures eliminate the network round
trips required to do complex logic which is sometimes performed by an
external application.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ilan Volow | 2008-01-22 17:19:18 | Re: Reason(s) not to use a stored procedure |
| Previous Message | Christoph Frick | 2008-01-22 15:29:20 | Re: Reason(s) not to use a stored procedure |