Thread: Re: How to speed-up inserts with jdbc

Re: How to speed-up inserts with jdbc

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