Re: Is it considered good practice to use stored procedures formost tasks?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Is it considered good practice to use stored procedures formost tasks?
Дата
Msg-id 0fe0d50a25af3604b680905901c7c3754c32b1f4.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Is it considered good practice to use stored procedures for most tasks?  (Gaetano Mendola <mendola@gmail.com>)
Ответы Re: Is it considered good practice to use stored procedures for most tasks?  (Laszlo Forro <getforum@gmail.com>)
Re: Is it considered good practice to use stored procedures for mosttasks?  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-novice
Дерево обсуждения 
Gaetano Mendola wrote:
> For sure do not allow your application to touch directly tables, use views and sp,
> lately I'm abandoning views for table functions.

As far as I know, a table function result is materialized on the server,
and you have to wait for the query to finish before you can retrieve the
first row.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

В списке pgsql-novice по дате отправления:

Предыдущее
От: Steve Horn
Дата:
Сообщение: Re: Is it considered good practice to use stored procedures for most tasks?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Is it considered good practice to use stored procedures for most tasks?