dart_postgresql
dart_postgresql copied to clipboard
Support for Copy
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.
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