Hi Tim,

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

Tim Bunce <[EMAIL PROTECTED]> 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.

Reply via email to