| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Val Ventura <darkcity(at)houston(dot)rr(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: speed of server side languages |
| Date: | 2002-10-04 15:52:22 |
| Message-ID: | 200210041552.g94FqNM07413@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Val Ventura wrote:
> I am new to PostgreSQL and I'm looking to port a MSSQL database. I am
> currently working on the stored procedures, and I'm trying to
> understand when and why I should choose SQL vs. PL/pgSQL vs. all the
> others, as far as performance goes.
>
> Is there a document that addresses when to use what, if compatibility
> is not an issue? I would probably be rewriting the gist of the stored
> procedures, instead of trying to port them line by line, so I don't
> care how different it is from T/SQL.
>
> My searches turned up nothing yet... I've seen the question asked a
> few times, but google ate the replies (if any).
PL/pgSQL is probably the fastest because it gets compiled on first
execution.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Welche | 2002-10-04 15:55:04 | Re: pg_restore authentication failure |
| Previous Message | Bruno Wolff III | 2002-10-04 15:49:38 | Re: psql scripts |