Re: Why are stored procedures looked on so negatively?
| От | Aaron Abreu |
|---|---|
| Тема | Re: Why are stored procedures looked on so negatively? |
| Дата | |
| Msg-id | CAF8_oV_2L55ru_7SdiLqf1YM+G1HMUEq2AgLS74+reovqNjSpQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Why are stored procedures looked on so negatively? (Some Developer <someukdeveloper@gmail.com>) |
| Ответы |
Re: Why are stored procedures looked on so negatively?
(Vincenzo Romano <vincenzo.romano@notorand.it>)
Re: Why are stored procedures looked on so negatively? (Vincenzo Romano <vincenzo.romano@notorand.it>) Re: Why are stored procedures looked on so negatively? (Merlin Moncure <mmoncure@gmail.com>) |
| Список | pgsql-general |
a NON-technical version...
st.procedures and automation are great...
but...
sounds like everybody is dancing around the main theme..so lets say it....
that dreaded word that developers and DBA's cring to hear...
the one part of our job that we all hate...
DOCUMENTATION !!!!!
My worst fear is simply this...
having to fix something somebody else wrote.. and they
are not there anymore..... and the only documentation is the code itself..
been there... on a few occasions just had to write something new...
On Tue, Jul 23, 2013 at 7:29 PM, Some Developer <someukdeveloper@gmail.com> wrote:
I've done quite a bit of reading on stored procedures recently and the consensus seems to be that you shouldn't use them unless you really must.
I don't understand this argument. If you implement all of your logic in the application then you need to make a network request to the database server, return the required data from the database to the app server, do the processing and then return the results. A stored procedure is going to be a lot faster than that even if you just take away network latency / transfer time.
I'm in the middle of building a database and was going to make extensive use of stored procedures and trigger functions because it makes more sense for the actions to happen at the database layer rather than in the app layer.
Should I use them or not?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
####
Aaron Abreu, Systems Consultant
Bay District Schools, Panama City, FL
Bay District Schools, Panama City, FL
Office: (850) 767-4288
>>FOCUS Student system support
>>FOCUS Student system support
>>IRIS phone alert system support
ABREUAL@bay.k12.fl.us
ABREUAL@bay.k12.fl.us
The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.
В списке pgsql-general по дате отправления:
Следующее
От: Vincenzo RomanoДата:
Сообщение: Re: Why are stored procedures looked on so negatively?