Re: How to speed-up inserts with jdbc

Поиск
Список
Период
Сортировка
От Leeuw van der, Tim
Тема Re: How to speed-up inserts with jdbc
Дата
Msg-id BF88DF69D9E2884B9BE5160DB2B97A85010D6F4B@nlshl-exch1.eu.uis.unisys.com
обсуждение исходный текст
Ответ на How to speed-up inserts with jdbc  (Michael Kleiser <mkl@webde-ag.de>)
Список 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: How to speed-up inserts with jdbc
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: seqscan strikes again