Re^3: DBI Style Inquiry


Do you know where your variables are?
	PerlMonks

Re^3: DBI Style Inquiry

by erix (Prior)

on Jun 28, 2013 at 12:14 UTC ( [id://1041238]=note: print w/replies, xml )

Need Help??

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)

Comment on Re^3: DBI Style Inquiry Download Code

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]