Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

DBI speed up needed on MySQL

by jacques (Priest)
on May 08, 2005 at 03:30 UTC ( #454953=perlquestion: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh->prepare("select * from campaigns where mw_export='yes'
    + and last_update > ?");
    $sth->execute(last_transfer{'campaigns'});
    ...
    print "It takes me over 30 minutes to print this!!!\n";
    
    }
    
  2. or download this
    alter table campaigns add index mw_export (mw_export);
    alter table campaigns add index last_update (last_update);
    

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (10)
As of 2014-10-24 13:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (131 votes), past polls