Re: Inserting 'large' amounts of data

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Inserting 'large' amounts of data
Дата
Msg-id 4A956E17.9020607@hogranch.com
обсуждение исходный текст
Ответ на Inserting 'large' amounts of data  (Mario Splivalo <mario.splivalo@megafon.hr>)
Ответы Re: Inserting 'large' amounts of data
Список pgsql-jdbc
Mario Splivalo wrote:
> I have a web application which allows users to upload a lot of phone
> numbers. I need to store those numbers to a database. Usualy, one would
> upload around 70k-100k of records, totaling around 2 MB in size.
>
> ...
> t would one recommend as the best way to insert those data?
>


I believe you can use org.postgresql.copy.CopyIn() ...  there are
variants that use a writeToCopy() call to send the data, or a
java.io.InputStream, or a java.io.Reader ...



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

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Inserting 'large' amounts of data
Следующее
От: Maciek Sakrejda
Дата:
Сообщение: Re: Inserting 'large' amounts of data