From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Sheer El-Showk <sheer(at)saraf(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: prepared statement performance |
Date: | 2001-07-10 00:42:54 |
Message-ID: | 3B4A4F8E.C5EAB5F1@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Perpared statements in postgres jdbc are converted on the java side and
then shipped to the backed, so there will no performance increase.
Sheer El-Showk wrote:
>
> Does anyone have some handy metrics of the performance advantage of
> prepared vs unprepared statements? I'm considering the case of an
> application which has to make multiple queries/inserts (30-100) per
> application transaction and which is currenlty generating the sql by
> building the strings on the fly then passing them to the JDBC. Can I
> expect significant (ie worth the recoding time) performance increases by
> converting the statements into prepared statements?
>
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2001-07-10 00:51:47 | Re: Re: Backups WAS: 2 gig file size limit |
Previous Message | Joseph Shraibman | 2001-07-10 00:40:29 | Shutdown hook imp |