On Tue, Sep 29, 2009 at 08:45:55AM -0700, Alan Hodgson wrote: > On Tuesday 29 September 2009, Sam Mason <sam@xxxxxxxxxxxxx> 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
