Re: DBD::Pg, DBD::Oracle and others are slow with threads due to DBIS

On Fri, Mar 16, 2012 at 02:18:00PM +0000, Martin J. Evans wrote:
> 
> Perl with threads:
>  1.42
>   read: 128 wallclock secs (86.11 usr +  5.41 sys = 91.52 CPU) @  0.11/s (n=10)
>   readperrow: 137 wallclock secs (95.33 usr +  4.86 sys = 100.19 CPU) @  0.10/s (n=10)
> 
> subversion trunk:
>   read: 94 wallclock secs (52.55 usr +  5.68 sys = 58.23 CPU) @  0.17/s (n=10)
>   readperrow: 104 wallclock secs (62.74 usr +  5.06 sys = 67.80 CPU) @  0.15/s (n=10)
> 
> which only goes to remind me why I don't use a Perl with threads but if you do, DBD::Oracle should be a fair bit faster now.

So 92 reduced to 58 cpu, and 100 reduced to 68.

Those are impressive gains!

> BTW, this change is literally thousands of lines of code so if you depend on DBD::Oracle I'd get a copy of the subversion trunk and try it.

Thanks for doing the work Martin!

Tim.