# # NB. Output edited and trimmed to fit the screen # COMPARE - FETCHING 1 COLUMN Benchmark: timing 5 iterations of fetchrow_array, fetchrow_hashref, fetchall_arrayref, fetchall_arrayref(buffered), fetchrow_arrayref... fetchrow_array: 5 secs ( 2.28 usr + 0.73 sys = 3.01 CPU) fetchrow_hashref: 11 secs ( 8.81 usr + 0.76 sys = 9.57 CPU) fetchall_arrayref: 5 secs ( 2.24 usr + 0.77 sys = 3.01 CPU) fetchall_arrayref(buf): 5 secs ( 2.57 usr + 0.74 sys = 3.31 CPU) fetchrow_arrayref: 4 secs ( 2.00 usr + 0.71 sys = 2.71 CPU) Rate fetchrow_hashref fetchall_arrayref(buffered) fetchall_arrayref fetchrow_array fetchrow_arrayref 1 2 3 4 5 1 fetchrow_hashref 0.522/s -- -65% -69% -69% -72% 2 fetchall_arrayref(buf) 1.51/s 189% -- -9% -9% -18% 3 fetchall_arrayref 1.66/s 218% 10% -- 0% -10% 4 fetchrow_array 1.66/s 218% 10% 0% -- -10% 5 fetchrow_arrayref 1.85/s 253% 22% 11% 11% -- COMPARE - FETCHING 10 COLUMNs Benchmark: timing 5 iterations of fetchrow_array, fetchrow_hashref, fetchall_arrayref, fetchall_arrayref(buffered), fetchrow_arrayref... fetchrow_array: 13 secs ( 9.92 usr + 1.03 sys = 10.95 CPU) fetchrow_hashref: 20 secs (16.97 usr + 1.07 sys = 18.04 CPU) fetchall_arrayref: 11 secs ( 6.64 usr + 1.09 sys = 7.73 CPU) fetchall_arrayref(buf): 11 secs ( 7.40 usr + 1.12 sys = 8.52 CPU) fetchrow_arrayref: 7 secs ( 3.81 usr + 0.99 sys = 4.80 CPU) s/iter -fetchrow_hashref ---fetchrow_array fetchall_arrayref(buffered) fetchall_arrayref fetchrow_arrayref 1 2 3 4 5 1 fetchrow_hashref 3.61 -- -39% -53% -57% -73% 2 fetchrow_array 2.19 65% -- -22% -29% -56% 3 fetchall_arrayref(buf) 1.70 112% 29% -- -9% -44% 4 fetchall_arrayref 1.55 133% 42% 10% -- -38% 5 fetchrow_arrayref 0.960 276% 128% 77% 61% -- COMPARE - FETCHING 20 COLUMNs Benchmark: timing 5 iterations of fetchrow_array, fetchrow_hashref, fetchall_arrayref, fetchall_arrayref(buffered), fetchrow_arrayref... fetchrow_array: 22 secs (16.91 usr + 1.24 sys = 18.15 CPU) fetchrow_hashref: 30 secs (24.53 usr + 1.14 sys = 25.67 CPU) fetchall_arrayref: 18 secs (11.99 usr + 1.10 sys = 13.09 CPU) fetchall_arrayref(buf): 19 secs (12.22 usr + 1.12 sys = 13.34 CPU) fetchrow_arrayref: 10 secs ( 5.17 usr + 1.26 sys = 6.43 CPU) s/iter fetchrow_hashref fetchrow_array fetchall_arrayref(buffered) fetchall_arrayref fetchrow_arrayref 1 2 3 4 5 1 fetchrow_hashref 5.13 -- -29% -48% -49% -75% 2 fetchrow_array 3.63 41% -- -27% -28% -65% 3 fetchall_arrayref(buf) 2.67 92% 36% -- -2% -52% 4 fetchall_arrayref 2.62 96% 39% 2% -- -51% 5 fetchrow_arrayref 1.29 299% 182% 107% 104% -- PROFILE - FETCHING 1 COLUMN DBI::Profile: 5.487208 seconds (300110 method calls) test_dbi_calls.pl 'FETCH' => 0.000013s 'STORE' => 0.000245s 'execute' => 2.471070s / 4 = 0.617767s avg 'fetchall_arrayref' => 0.236404s / 101 = 0.002341s avg 'fetchrow_array' => 0.255235s / 100001 = 0.000003s avg 'fetchrow_arrayref' => 0.270196s / 100001 = 0.000003s avg 'fetchrow_hashref' => 2.254045s / 100001 = 0.000023s avg PROFILE - FETCHING 10 COLUMNs DBI::Profile: 8.832431 seconds (300110 method calls) test_dbi_calls.pl 'FETCH' => 0.000004s 'STORE' => 0.000219s 'execute' => 3.649873s / 4 = 0.912468s avg 'fetchall_arrayref' => 0.930104s / 101 = 0.009209s avg 'fetchrow_array' => 0.536815s / 100001 = 0.000005s avg 'fetchrow_arrayref' => 0.498186s / 100001 = 0.000005s avg 'fetchrow_hashref' => 3.217229s / 100001 = 0.000032s avg PROFILE - FETCHING 20 COLUMNs DBI::Profile: 12.905533 seconds (300110 method calls) test_dbi_calls.pl 'FETCH' => 0.000006s 'STORE' => 0.000219s 'execute' => 5.516249s / 4 = 1.379062s avg 'fetchall_arrayref' => 1.488744s / 101 = 0.014740s avg 'fetchrow_array' => 0.758613s / 100001 = 0.000008s avg 'fetchrow_arrayref' => 0.690056s / 100001 = 0.000007s avg 'fetchrow_hashref' => 4.451645s / 100001 = 0.000045s avg