plpgsql functions vs. embedded queries - Mailing list pgsql-novice

From Wright, George
Subject plpgsql functions vs. embedded queries
Date
Msg-id 51548D6D5BEB57468163194A8C1A0E980161A5D4@MAGPTCPEXC02.na.mag-ias.net
Whole thread Raw
Responses Re: plpgsql functions vs. embedded queries
List 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?

pgsql-novice by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: absolute novice wanting knowledgeable opinion about front end
Next
From: John DeSoi
Date:
Subject: Re: plpgsql functions vs. embedded queries