dart_postgresql icon indicating copy to clipboard operation
dart_postgresql copied to clipboard

Support for Copy

Open trailsandtribulations opened this issue 12 years ago • 1 comments

in postgresql, the fastest way (by far) to insert rows is through copy.

for larger datasets, this is even faster than prepared statements due to, if nothing else, communication and parsing overhead.

imho this would be right up there with pooling (which you already have) in making pg production ready.

trailsandtribulations avatar Nov 21 '13 04:11 trailsandtribulations

Thanks for opening the issue.

I won't be able to implement this within the next months, for anyone interested in implementing this, the protocol documentation is here:

http://www.postgresql.org/docs/8.1/static/protocol-flow.html#PROTOCOL-COPY

xxgreg avatar Nov 23 '13 21:11 xxgreg