Re: Stored procedures returning rowsets - Mailing list pgsql-general

From Mario Weilguni
Subject Re: Stored procedures returning rowsets
Date
Msg-id 00f801c242ad$6c9402d0$6f01c00a@icomedias.com
Whole thread Raw
In response to Re: Stored procedures returning rowsets  (Mark Kirkwood <markir@slingshot.co.nz>)
List pgsql-general
> As I understand it, every query goes through the stages of
> parse,execute, [and possibly fetch(es)].
> Stored procedures can only save you the parse phase (at best) - which is
> usually a tiny component of the total cost/elapsed time (and when it is
> not, then you probably have a data warehouse with an ad-hoc query tool

I'm not so sure about this, parsing can be quite expensive for small result
sets.



pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Stored procedures returning rowsets
Next
From: "Jaroslaw Nozderko"
Date:
Subject: Re: Stored procedures returning rowsets