| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Altaf Malik <mmalik_altaf(at)yahoo(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Function with raise notice statements taking too long |
| Date: | 2010-05-26 19:21:33 |
| Message-ID: | alpine.BSO.2.00.1005261516270.15571@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Wed, 26 May 2010, Altaf Malik wrote:
> I have a plpgsql function with raise notice statements in a loop. When I
> call this function from JDBC, it takes almost 5 minutes to execute. However,
> if I invoke it through pgAdminIII, it gets executed in just 12 seconds. The
> code of the function is given below:
>
> [plpgsql function issuing a ton of RAISE NOTICE statements]
>
> Any clue why JDBC is performing too slow?
>
I've committed a fix to CVS to fix this performance issue. We were
only tracking the head of the SQLWarning list so adding a new warning
was O(N). Now we track the tail of the list as well, so adding new
warnings is quick.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2010-05-27 03:44:15 | Re: New code: Easy PKCS#12 client certificate support for pgjdbc |
| Previous Message | Altaf Malik | 2010-05-26 08:50:16 | Function with raise notice statements taking too long |