Re: [PERFORM] How to speed-up inserts with jdbc

[Leeuw van der, Tim]

Hi,

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

Advertising

--Tim


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Kleiser
Sent: Wednesday, November 10, 2004 2:52 PM
To: Jeff
Cc: Shane|SkinnyCorp; [EMAIL PROTECTED]
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')");
[...]

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend