Have been playing with making DBD::Oracle more compatible with threaded 
Perl.

As suggested in the DBD Driver Writer's guide I added PERL_NO_GET_CONTEXTit 
before the #include <DBIXS.h> in the Oracle file and dTHX; where required in 
the other files.

Well here are the results;

Calls that just use OCI, ie. bulk inserts like $dbh->do ('Insert into foo 
(select * from foo_bar)')  I see no change (as I would expect as Perl is not 
really involved in it)

But calls that use Perl such as $sth->fetchrow() I get a net benefit of 
about 6% to 7%.

Any other DBD developers out there seen an improvement like this?

Anyone got some test scripts that will gather some more results than the 
little test I cam up with.


The only disadvantage I can see with it is it makes your DBD driver 
dependent on DBI v1.51

Cheers
John Scoles 


Reply via email to