Re: JDBC prepared statement: a 32767 limit of arguments number

Поиск
Список
Период
Сортировка
От Sehrope Sarkuni
Тема Re: JDBC prepared statement: a 32767 limit of arguments number
Дата
Msg-id CAH7T-ap-4i6Qinbjw8Kn1NZ6WUdYjGHLCUE_i_WxmnUtkAe+7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JDBC prepared statement: a 32767 limit of arguments number  (Dave Cramer <davecramer@postgres.rocks>)
Список pgsql-jdbc
Дерево обсуждения
On Fri, Mar 11, 2022 at 8:55 AM Dave Cramer <davecramer@postgres.rocks> wrote:
I'd be willing to bet it's pretty close to COPY. Do we have any numbers ?

You'd win that bet.

I just tried it out with 25K inserts using eithers VALUES, UNNEST arrays, and COPY IN. 

In a completely unscientific test on my active machine, the array and COPY IN were on par with each other, running in about 30-40ms.

Both of them were 250x faster than using individual separate statements with VALUES.

Regards,
-- Sehrope Sarkuni
Founder & CEO | JackDB, Inc. | https://www.jackdb.com/

 

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: JDBC prepared statement: a 32767 limit of arguments number
Следующее
От: Blake McBride
Дата:
Сообщение: JDBC: ERROR: portal "C_2" does not exist