in reply to Re^2: DBI Style Inquiry
in thread DBI Style Inquiry

I am surprised by the difference (even if it's small) between fetch and fetchrow_arrayref (your BC and DBC), as DBI docs say: 

   "fetchrow_arrayref"
      $ary_ref = $sth->fetchrow_arrayref;
      $ary_ref = $sth->fetch;    # alias

[download]

Or is the essential difference something else?

(Also, it would be interesting to have the DBMS version-numbers on those pages; it does say 2006, that's a long time ago. I would say that (arguably, no doubt) PostgreSQL has advanced more than the others in performance in this particular period)

Replies are listed 'Best First'.
Re^4: DBI Style Inquiry
by Tux (Canon) on Jun 28, 2013 at 12:42 UTC

    The difference between BC and DBC is the method-call overhead. If you really want to squeze out nonoseconds per call, it matters. It is not something I would propagate in use though:

     Create table 5000 x 12
Dbindcol     660153.156  recs/sec    4.8 x faster  DBC
bindcol      633472.697  recs/sec    4.6 x faster  BC
Darrayref    563380.282  recs/sec    4.1 x faster  DAR
arrayref     525486.075  recs/sec    3.8 x faster  AR
array        227086.929  recs/sec    1.7 x faster  A
hashref      136836.344  recs/sec                  HR

    [download]
    Read more... (2 kB)

    Enjoy, Have FUN! H.Merijn
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom