On Fri, May 24, 2002 at 04:40:16PM +0100, Tim Bunce wrote: > On Tue, May 21, 2002 at 12:41:47AM +0100, Tim Bunce wrote: > > > > In other words just prepares a statement, creating and destroying > > a statement handle, over and over again. Using the real DBI the loop > > runs at ~4550 handles per second but DBI::PurePerl can only manage > > ~230 per second on the same machine. > > I've been doing some surgery on it and introduced the inner/outer > handle concept (using $inner = tied %$outer) and that, along with > some other changes has raised the performance of the prepare loop > from 230/sec to 2310/sec! Mainly by avoiding a bazillion calls to > FETCH to get attribute values.
I've just released DBI 1.23 (annoucement to follow) and DBI::PurePerl now runs that loop at 2800/sec :) [when DBI_TRACE is unset] That's good enough for me! I'll be moving on to other DBI enhancements now... Tim.
