Re: Is it considered good practice to use stored procedures for mosttasks?

Поиск
Список
Период
Сортировка
Искать
От
Thomas Kellerer
Тема
Re: Is it considered good practice to use stored procedures for mosttasks?
Дата
Msg-id
q99pjs$4fdm$1@blaine.gmane.org
Ответ на
Re: Is it considered good practice to use stored procedures formost tasks? (Laurenz Albe)
Список
Дерево обсуждения
Is it considered good practice to use stored procedures for mosttasks? Simon Connah <scopensource@gmail.com>
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 formost tasks? Laurenz Albe <laurenz.albe@cybertec.at>
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>
Re: Is it considered good practice to use stored procedures for most tasks? Steve Horn <steve@stevehorn.dev>
Re: Is it considered good practice to use stored procedures for most tasks? Gaetano Mendola <mendola@gmail.com> 
Laurenz Albe schrieb am 18.04.2019 um 10:36:
>> 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.

Is that true for SQL functions as well? 

Especially when they are inlined, I can't imagine they are handled differently than a regular query. 

Thomas
В списке pgsql-novice по дате отправления
Предыдущее
От: Laszlo Forro
Дата:
Следующее
От: Pól Ua Laoínecháin
Дата:
FAQ