Is this possible / slow performance?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-Performance (E-mail)" <pgsql-performance(at)postgresql(dot)org>
Subject: Is this possible / slow performance?
Date: 2005-02-07 11:36:24
Message-ID: A3D1526C98B7C1409A687E0943EAC410605EEE@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi every one,

Why does this take forever (each query is sub second when done seperately)?
Is it because I cannot open two cursors in the same transaction?

begin;

declare SQL_CUR01 cursor for
SELECT A.ordernummer, B.klantnummer FROM "orders" A LEFT OUTER JOIN "klt_alg" B ON A.Klantnummer=B.Klantnummer ORDER BY A.klantnummer;
fetch 100 in SQL_CUR01;

declare SQL_CUR02 cursor for
SELECT A.ordernummer, B.klantnummer FROM "orders" A LEFT OUTER JOIN "klt_alg" B ON A.Klantnummer=B.Klantnummer ORDER BY A.klantnummer desc;
fetch 100 in SQL_CUR02;

commit;

TIA

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-02-07 11:46:05 Re: Index not used with or condition
Previous Message Antony Paul 2005-02-07 11:14:07 Re: Index not used with or condition