From: Sean Chittenden <sean@...>
Date: 2002-05-24T07:23:51+09:00
Subject: Re: dbi pg_dbd performance

> Has anybody else found that the ruby dbi + pg_dbd performance to be slow?
> 
> I'm running a unit test that selects all the records in a single
> PostgreSQL table. I'm finding that the select of about 300 records
> takes about 0.2sec using the direct ruby postgres binding while the
> DBI takes anywhere from 2.8-6 seconds.

What version of DBI are you using?  Can you upgrade?  There have been
major speed improvements in DBD::Pg recently that have significantly
reduced the time it takes to perform operations that return a row
(factor of a thousand or so).  -sc

-- 
Sean Chittenden