Skip site navigation (1) Skip section navigation (2)

Re: plpgsql functions vs. embedded queries

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: plpgsql functions vs. embedded queries
Date: 2008-09-29 17:45:17
Message-ID: 51548D6D5BEB57468163194A8C1A0E980161A5DF@MAGPTCPEXC02.na.mag-ias.net (view raw or flat)
Thread:
Lists: pgsql-novice
I did neither but will try both, thank you.

The functions took on average more than 10 times as long.


-----Original Message-----
From: John DeSoi [mailto:desoi(at)pgedit(dot)com] 
Sent: Monday, September 29, 2008 1:16 PM
To: Wright, George
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] plpgsql functions vs. embedded queries


On Sep 29, 2008, at 9:50 AM, Wright, George wrote:

> 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?

I'd say no, they should not always be slower. Did you try preparing  
your PHP call to the function? Did you mark your function as STABLE if  
you are not modifying the database?


John DeSoi, Ph.D.





In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-09-29 23:07:11
Subject: Re: plpgsql functions vs. embedded queries
Previous:From: John DeSoiDate: 2008-09-29 17:15:33
Subject: Re: plpgsql functions vs. embedded queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group