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 <laurenz.albe@cybertec.at>)
Список pgsql-novice
Дерево обсуждения 
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
Дата:
Сообщение: Re: Is it considered good practice to use stored procedures for most tasks?
Следующее
От: Pól Ua Laoínecháin
Дата:
Сообщение: Want records to be UNIQUE. When searching for dupes, stop on firstmatching record.