plpgsql functions vs. embedded queries

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: plpgsql functions vs. embedded queries
Date: 2008-09-29 13:50:49
Message-ID: 51548D6D5BEB57468163194A8C1A0E980161A5D4@MAGPTCPEXC02.na.mag-ias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2008-09-29 17:15:33 Re: plpgsql functions vs. embedded queries
Previous Message Obe, Regina 2008-09-29 04:49:53 Re: absolute novice wanting knowledgeable opinion about front end