PQputline in BINARY mode? - Mailing list pgsql-interfaces

From pacquet@newsguy.com
Subject PQputline in BINARY mode?
Date
Msg-id 200208132141.OAA71833@newsguy.com
Whole thread Raw
Responses Re: PQputline in BINARY mode?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
OK, I've tested both a

COPY BINARY <table> FROM <file>

which was very fast, and now I've also done:


PQputline(conn, <test ascii string>)


the question is, can I combine both techniques, and use a programmatic
interface to copy binary information?  We have an data collection application
which needs to insert a huge amount of (binary) information very quickly, so
I'm interested in squeezing out every last CPU cycle.  (any other tips you
have will also be appreciated).  Thanks



pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: ECGP - varchar in struct?
Next
From: Wei Weng
Date:
Subject: concurrent connections is worse than serialization?