On Wed, 10 Nov 2004 14:51:57 +0100, Michael Kleiser <[EMAIL PROTECTED]> wrote:
> Statement st = con.createStatement();
> java.sql.Timestamp datum = new java.sql.Timestamp(new
> Date().getTime());
> Date start = new Date();
> System.out.println(start);
> for (int i=0; i<100; ++i) {
> st.executeUpdate("insert into
> history(uuid,coni,date,direction,partner,type)
> values('uuid','content','"+datum+"','dir','partner','type')");
> }
Advertising
how about using PreparedStatment? that's on the java end.
on the pg end, maybe do a BEGIN before the for loop and
END at the end of the for loop.
--
i'm not flying. i'm falling... in style.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
