Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

$dbh->prepare() and execute() take too long?

by jbrugger (Parson)
on Mar 07, 2006 at 06:41 UTC ( #534840=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    select ra.value, ra.ra_id, q.id as q_id, q.qid , q.parent, q.q, q.type
    +, p.qid as pqid, if($ifstatement,'1','0') as selection , r.rpid from 
    +r, ra, q left join q p on q.parent = p.id where r.id = ra.ra_id and r
    +.q in (3,4,5) and ra.q = q.id order by ra.ra_id ASC,selection desc;
    
  2. or download this
    my $bm=  DEBUG_Benchmark->new();
    $bm->bmStart();
    ...
    
    $bm->bmStop();
    print $bm->getBmResult();
    
  3. or download this
    value    ra_id    q_id    qid    parent    q(4,5,6)type    pqid    sel
    +ection    rpid
    1    5501    1918917    34    0    4    6    NULL    1    ed94d62745f5
    +2f83cc6225c46cd1f012
    ...
    2    5501    1918940    31    0    4    6    NULL    1    ed94d62745f5
    +2f83cc6225c46cd1f012
    6    5501    1918916    30    0    4    6    NULL    1    ed94d62745f5
    +2f83cc6225c46cd1f012
    ...
    
  4. or download this
    uml:
    Command line: *** Benchmark *** : Execute: 4.636518 seconds
    ...
    life:
    Command line: *** Benchmark *** : Execute: 3.079879 seconds
    From Apache : *** Benchmark *** : Execute: 3.066677 seconds
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://534840]
Approved by spiritway
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2020-07-07 13:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?