Re: AutoCommit and DBI::Proxy driver

Hi Tim,

Sorry it's been a while, I was on holiday.

Tim Bunce <Tim.Bunce@xxxxxxxxx> wrote on 26/09/2006 23:36:06:

Can you try the version in the svn repository. For how, see
http://search.cpan.org/~timb/DBI-1.52/DBI.pm#CONTRIBUTING

Let me know how it goes.

I can confirm that AutoCommit now switches on and off correctly, so
multiple transactions (begin_work/commits) now work as expected.


Also, please setup a little test script that uses selectall_arrayref
to fetch from the server. Time how long it takes with a select that
fetches, say, a few thousand rows. Then add this like to the code:
sub DBD::Proxy::db::selectall_arrayref;
are time it again.

I tried that but when I added the sub, $dbh->selectall_arrayref returned
an undef value (quite quickly: 0.26769s vs 8.144393s without). I had
RaiseError on but no error was reported.

As a side issue, I started to wonder how large result sets would get on
with RPC::PlServer's maxmessage option, since I assume the intention is to
return the results in 1 message. (maxmessage defaults to 64K, but the pod
doesn't mention if you can disable it completely -- I've been bitten by it
before).


Thanks!

Tim.

No, my thanks to you :-)

best regards, John.

.