2007/10/7, Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx>: > Faster by calling external or internal libraries. my concept was calling > libraries internal to the system would make it faster right ? > I thing, so it's not true, because all libraries functions are directly called. It is different than Microsoft Windows. Pavel > > On 10/7/07, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > > 2007/10/7, Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx>: > > > My stored procedure is in Perl. Does that really make any difference ? > > > > > It depends. If you call external libraries you can be little bit > > faster. You have to test it. > > > > Pavel > > > > > > > > > On 10/7/07, Pavel Stehule <pavel.stehule@xxxxxxxxx > wrote: > > > > Hello > > > > > > > > If your stored procedure is writen in C language, then storing it > > > > inside PostgreSQL hasn't any benefit. There is only one difference .. > > > > loading library needs some time, but you can load any library with > > > > statement LOAD. > > > > > > > > Regards > > > > Pavel Stehule > > > > > > > > > > > > > > > > > > > > > > > > 2007/10/7, Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx>: > > > > > Hi, > > > > > > > > > > I have a stored procedure that gets called every now and then in my > > > system. > > > > > This stored procedure is an implementation of client socket code > > > basically. > > > > > > > > > > If somehow this stored procedure becomes a part of Postgres source > code, > > > > > would it really make any difference as far as performance and > resource > > > > > utilization of my system is concerned ? > > > > > > > > > > Thanks, > > > > > Hapreet > > > > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
