Re: How to speed-up inserts with jdbc

["Leeuw van der, Tim" <tim.leeuwvander@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx]On Behalf Of Michael Kleiser
Sent: Wednesday, November 10, 2004 2:52 PM
To: Jeff
Cc: Shane|SkinnyCorp; pgsql-performance@xxxxxxxxxxxxxx
Subject: 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')");
[...]