On Tue, Sep 29, 2009 at 08:45:55AM -0700, Alan Hodgson wrote:
> On Tuesday 29 September 2009, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
> > it's faster is because
> > parsing CSV data is easier than parsing SQL.
> >
> > At least I think that's the only difference; anybody know better?
>
> I think a big reason is also that the client can stream the data without
> waiting for a network round trip ack on every statement.
I don't think so. I'm pretty sure you can send multiple statements in a
single round trip. libpq is defined to work in such cases anyway:
http://www.postgresql.org/docs/current/static/libpq-exec.html
--
Sam http://samason.me.uk/