Re: best practice for use of functions..

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Chris Ochs" <chris(at)paymentonline(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: best practice for use of functions..
Date: 2004-01-15 02:26:22
Message-ID: 873cai3q29.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Ochs" <chris(at)paymentonline(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allen Landsidel 2004-01-15 03:50:29 Re: best practice for use of functions..
Previous Message Martin Marques 2004-01-15 00:50:23 Re: Postgress and MYSQL