Skip site navigation (1) Skip section navigation (2)

Re: Reason(s) not to use a stored procedure

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 (view raw or flat)
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/

pgsql-novice by date

Next:From: Ilan VolowDate: 2008-01-22 17:19:18
Subject: Re: Reason(s) not to use a stored procedure
Previous:From: Christoph FrickDate: 2008-01-22 15:29:20
Subject: Re: Reason(s) not to use a stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group