Re: How to speed-up inserts with jdbc - Mailing list pgsql-performance

From Leeuw van der, Tim
Subject Re: How to speed-up inserts with jdbc
Date
Msg-id BF88DF69D9E2884B9BE5160DB2B97A85010D6F4B@nlshl-exch1.eu.uis.unisys.com
Whole thread Raw
In response to How to speed-up inserts with jdbc  (Michael Kleiser <mkl@webde-ag.de>)
List 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@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')");
[...]

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: How to speed-up inserts with jdbc
Next
From: "Jim C. Nasby"
Date:
Subject: Re: seqscan strikes again