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