Re: [Ruby-DBI-devel] Repost from Yahoo! Groups -- speed differences

[Sean C. <se...@ch...>]

> Looking at sql.rb, there is some code that does a case to type bind
> parameters. Numeric is the fall-through case, which seems odd since
> numeric ids are so common. Perhaps moving it to the top could save a
> few string comparisons?
>
> I am willing to lose a little performance in exchange for all of the
> cool things that DBI gives me, but I can't imagine the gulf should be
> so wide. I am going to continue testing and make sure I didn't just
> do something totally crazy and wrong, but in the mean time, I wonder
> if any optimization fiends want to look at the DBD_Pg and DBI code?

Could you cook up a simple table definition, the SQL that you're
using, and an example of the volumne of the data (or the type of
data)?  -sc

-- 
Sean Chittenden