Re: How to speed-up inserts with jdbc

From: "Leeuw van der, Tim" <tim(dot)leeuwvander(at)nl(dot)unisys(dot)com>
To: <mkl(at)webde-ag(dot)de>, "Jeff" <threshar(at)torgo(dot)978(dot)org>
Cc: "Shane|SkinnyCorp" <shanew(at)skinnycorp(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to speed-up inserts with jdbc
Date: 2004-11-10 14:26:20
Message-ID: BF88DF69D9E2884B9BE5160DB2B97A85010D6F4B@nlshl-exch1.eu.uis.unisys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Try using parametrized prepared statements, does that make a difference? Or does PGSQL jdbc not support them in your version?

--Tim

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org]On Behalf Of Michael Kleiser
Sent: Wednesday, November 10, 2004 2:52 PM
To: Jeff
Cc: Shane|SkinnyCorp; pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] How to speed-up inserts with jdbc

[...]
> Statement st = con.createStatement();
[...]
st.executeUpdate("insert into history(uuid,coni,date,direction,partner,type) values('uuid','content','"+datum+"','dir','partner','type')");
[...]

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2004-11-10 16:52:34 Tuning suggestions wanted
Previous Message Dave Cramer 2004-11-10 14:05:37 Re: How to speed-up inserts with jdbc