Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

'DBD oddities' talk at Amsterdam.pm

by kudra (Vicar)
on Mar 09, 2001 at 22:09 UTC ( [id://63290]=perlmeditation: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
        my $sth = $sth->prepare ("select field from table");
        $sth->execute;
    ...
        my $field;
        $sth->bind_columns (\$field);
        $sth->fetch;                      # fastest
    
  2. or download this
        my $sth = prepex (
            "select field1,  field2",
    ...
        while ($sth->fetch) {
            :
            }
    
  3. or download this
    UNIFY
    ============== Benchmarks (2500 records)
    ...
        array:  76 wallclock secs ( 73.85 usr +  0.47 sys =  74.32 CPU) 12
    +774.60 rec/s  47.30 %
     arrayref:  73 wallclock secs ( 70.89 usr +  0.42 sys =  71.31 CPU) 13
    +313.80 rec/s   4.22 %  53.51 %
      bindcol:  69 wallclock secs ( 67.44 usr +  0.47 sys =  67.91 CPU) 13
    +980.40 rec/s   5.01 %           61.20 %
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlmeditation [id://63290]
Approved by root
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (7)
As of 2024-04-23 18:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found