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.
I'm using tomcat as an application server, and JDBC to connect to pg8.3
I will have around 20-50 concurent users in peek hours, and even that is
I could create the temporary file on the filesystem where database
cluster is located and then execute COPY mytable FROM
'/tmp/upload-data/uuidofsomesort.csv' WITH CSV', but the 'problem' is
that database server and tomcat reside on different physical machines.
What would one recommend as the best way to insert those data?
pgsql-jdbc by date
|Next:||From: John R Pierce||Date: 2009-08-26 17:17:11|
|Subject: Re: Inserting 'large' amounts of data|
|Previous:||From: Maciek Sakrejda||Date: 2009-08-26 09:01:51|
|Subject: Re: PGStream synchronization|