jdbc performance tips?

From: "Brett" <brettonator(at)excite(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jdbc performance tips?
Date: 2002-10-02 07:10:39
Message-ID: 20021002071039.536C0B6E3@xmxpita.excite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Does anyone have performance tips for someone who is writing a jdbc app from scratch? I'm open to any jdbc versions and I'd prefer if the postgresql server isn't beta. Should I avoid prepared statements? What if I want to get the sequence ID for an insert, do I need two roundtrips, one for getting the sequence ID, another for the insert? Don't most databases allow you to do one insert to get the sequence ID, implementing it with one round trip?Thanks for any help/tips.

------------------------------------------------
Changed your e-mail? Keep your contacts! Use this free e-mail change of address service from Return Path. Register now!

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jeroen Olthof 2002-10-02 08:02:12 This method is not yet implemented.
Previous Message dmitriy 2002-10-02 03:56:29 jdbc driver question