Re: best practice for use of functions.. - Mailing list pgsql-general

From Doug McNaught
Subject Re: best practice for use of functions..
Date
Msg-id 873cai3q29.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to best practice for use of functions..  ("Chris Ochs" <chris@paymentonline.com>)
Responses Re: best practice for use of functions..  (Allen Landsidel <all@biosys.net>)
List 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 by date:

Previous
From: Martin Marques
Date:
Subject: Re: Postgress and MYSQL
Next
From: Allen Landsidel
Date:
Subject: Re: best practice for use of functions..