Re: best practice for use of functions..

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: best practice for use of functions..
Дата
Msg-id 873cai3q29.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на best practice for use of functions..  ("Chris Ochs" <chris@paymentonline.com>)
Ответы Re: best practice for use of functions..  (Allen Landsidel <all@biosys.net>)
Список pgsql-general
"Chris Ochs" <chris@paymentonline.com> writes:

> My preferred method is to have a function for each table that I do an insert
> into, it's easier to manage that way and a lot easier to make changes if I
> add/drop columns and tables.  Right now I have one function that is called
> by my application that in turn calls all the other functions.
>
> I am wondering is there is a significant overhead for calling say 10
> functions from within a function compared to putting everything into one
> single function?

Compared to the disk I/O overhead for a transaction, it'd be lost in
the noise--do whatever makes you happy.  :)

-Doug

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

Предыдущее
От: Martin Marques
Дата:
Сообщение: Re: Postgress and MYSQL
Следующее
От: Allen Landsidel
Дата:
Сообщение: Re: best practice for use of functions..