Re: speeding up XS_DBI_dispatch()

2012-01-29 Thread Dave Mitchell
On Wed, Jan 25, 2012 at 04:14:07PM +, Dave Mitchell wrote: then the CPU usage of the while loop broke down as follows: 7.0% overhead of loop, i.e. while() {$c++} 19.2% handle the outer method call, i.e. $sth-fetch() of which half is method lookup,

Re: Any reason not to make a new DBI release?

2012-01-29 Thread Martin J. Evans
On 28/01/2012 10:41, Tim Bunce wrote: I'd like to make a formal DBI release soon. DBI-1.616_901 tested well and I've just uploaded DBI-1.616_902. Any reason I shouldn't upload as DBI-1.617 soon? Tim. I'd be happy with that as I'm looking forward to asking people to use DBI_TRACE=DBD. I've

Re: speeding up XS_DBI_dispatch()

2012-01-29 Thread Tim Bunce
On Sun, Jan 29, 2012 at 06:12:50PM +, Dave Mitchell wrote: I've now written some working caching code, that reduces CPU usage on while ($sth-fetch()) {$c++} from 15.23s to 13.10s, which is a 14% saving!! The test code just fetches millions of rows from a 2-int table and then doesn't do