Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 29 Sep 2008 08:50:49 -0500
- Message-id: <51548D6D5BEB57468163194A8C1A0E980161A5D4@MAGPTCPEXC02.na.mag-ias.net> <text/plain>
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?
- Follow-Ups:
- Re: plpgsql functions vs. embedded queries
- From: John DeSoi
- Re: plpgsql functions vs. embedded queries
- Prev by Date: Re: absolute novice wanting knowledgeable opinion about front end
- Next by Date: Re: plpgsql functions vs. embedded queries
- Previous by thread: absolute novice wanting knowledgeable opinion about front end
- Next by thread: Re: plpgsql functions vs. embedded queries
- Indexes: