[postgis-users] Performance Help

[Mark Cave-Ayland]

On Thu, 2007-07-26 at 13:52 +0000, Alan Cunnane wrote:
> By stored procedures what do you mean exactly? Do you mean in a Perl
> script or something similar?

Nearly. The advantage of stored procedures is that they are a type of
function that executes on the server. They are typically used for SQL
statements, however you can also do interesting things like FOR loops
and IF statements.

The main language for stored procedures is PL/PGSQL
(http://www.postgresql.org/docs/8.2/interactive/plpgsql.html), but if
you're more familiar with Perl, you'll probably find PL/Perl easier to
get along with
(http://www.postgresql.org/docs/8.2/interactive/plperl.html).


HTH,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk