| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
| Cc: | "Joseph M(dot) Day" <jday(at)gisolutions(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporary Tables |
| Date: | 2005-04-01 15:56:45 |
| Message-ID: | 1112371004.13798.30.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2005-04-01 at 04:32, Alban Hertroys wrote:
> Joseph M. Day wrote:
> > Just out of curiosity, what is the performance of this? In MSSQL the
> > only way to do something equivalent to this was to use a cursor. Cursors
> > are painfully slow, so they are to be used as a last resort.
>
> On what do you base that cursors are slow?
I'm guessing that in MSSQL, cursors are slow, so the original poster
simply assumed that on all other databases, cursors are slow.
I can assure him that in PostgreSQL they are not any slower than any
other method of accessing data i've used, and usually faster.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl O. Pinc | 2005-04-01 16:19:55 | Best practices for (plpgsql ?) trigger optimization? |
| Previous Message | Chandra Sekhar Surapaneni | 2005-04-01 15:54:09 | Re: Help with converting hexadecimal to decimal |