plpgsql functions vs. embedded queries

Поиск
Список
Период
Сортировка
От Wright, George
Тема plpgsql functions vs. embedded queries
Дата
Msg-id 51548D6D5BEB57468163194A8C1A0E980161A5D4@MAGPTCPEXC02.na.mag-ias.net
обсуждение исходный текст
Ответы Re: plpgsql functions vs. embedded queries  (John DeSoi <desoi@pgedit.com>)
Список pgsql-novice

Are funtions in plpgsql always slower than embedding sql queries in string form in code like PHP?

I ran several tests and they seemed to always perform that way. I would have thought the pre-planning would have made them faster.

Would re-writing the functions C make them faster than the embedded queries?

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

Предыдущее
От: "Obe, Regina"
Дата:
Сообщение: Re: absolute novice wanting knowledgeable opinion about front end
Следующее
От: John DeSoi
Дата:
Сообщение: Re: plpgsql functions vs. embedded queries