On Fri, 2007-09-07 at 10:43 +0100, Tim Bunce wrote: > On Fri, Sep 07, 2007 at 03:02:09PM +0800, Ow Mun Heng wrote: > > 'execute' => 0.249191s > > 'prepare' => 0.000489s > > 'fetchrow_arrayref' => 0.800888s / 15319 = 0.000052s avg (first 0.000633s, > > min 0.000010s, max 0.005775s) > > > > 'prepare' => 0.000216s > > 'execute' => 0.027413s > > 'fetchrow_array' => 0.789209s / 15319 = 0.000052s avg (first 0.001905s, min > > 0.000025s, max 0.010331s) > > Note the wildly different prepare() and execute() times between the two runs. > (I'm trusting here that the query itself is the same.)
Yes it is. But as mentioned network load etc convulates things a bit > And even if you could, it should be clear that the difference is but a > tiny fraction of the overall time spent processing the query. Just wanted to ensure that I make full use of the efficiency of the relevent pull methods are stated in your talk. Since there's no discernible difference, I'll leave it as it is.. Thanks for the input.
