Re: insert performance riddle

On Thursday August 11 2005 1:37 pm, Michael Fuhr wrote:
> Have you done any client-side tests that eliminate Perl?  I'd
> suggest writing a little C program so you can measure libpq's
> performance without the extra layers of Perl and DBI/DBD::Pg.
>  Test both local (Unix socket) and network (IPv4 or IPv6
> socket) connections.

Michael, you nailed it again.  My libpq test C program delivered
between 2400 QPS and 5000 QPS vs ~10 QPS for DBI/DBD::Pg on this
box.

It remains unclear to me why the same DBI/DBD::Pg client code
would deliver performance 2-3 orders of magnitude better on
other roughly comparable or inferior boxes.

What would be the recommended replacement for DBI/DBD::Pg as a
perl interface?

Thanks,
Ed