I am pretty sure I know this already, but every time you run a Pl/PerlYou can also preload (if you are running Mammoth or 7.4) the plperl.so which should
function it is just like running a perl script as far as having to load and
compile the code right? My application runs under mod perl so I'm thinking
that speed is not something I would gain by putting any of the code into the
database server via Pl/Perl.
give you a speed increase.
It entirely depends on what you are trying to do with pl/Perl however. If you need
access to tuple data (ability to modify records etc...) then your kind of out of luck.
However, if you are using it to perform logic and then spit back the results pl/Perl
could be very useful and give a speed increase.
The speed increase would come from only returning the results of your calculation
versus returning a set of data and then performing calculations on that set and then
displaying it.
Sincerely,
Joshua D. Drake
Chris
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
