Christopher Condit wrote:
Thanks for your response, Josh. Actually I'm looking for the most
general way to do this, since my remote database might not be psql. In
fact, I will probably be streaming through a java process. So I'd like
to go from the java process directly into the psql db. Is it still
possible?
I think recent JDBC drivers allow COPY, but you'll need to check the
documentation.
The other thing to do is to batch your inserts into groups of (say)
1000. That will provide a real speed increase.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
