Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: DBI speed up needed on MySQL

by Anonymous Monk
on May 09, 2005 at 04:21 UTC ( #455089=note: print w/ replies, xml ) Need Help??


in reply to DBI speed up needed on MySQL

Hmm ... when ever I want to speed up my select statements I do this first

mysql> delete from campaigns; mysql> commit;
That should speed things up, but you 'd lose all your data. If you don't want to lose your data try creating a index on the columns you are using in your where clause.


Comment on Re: DBI speed up needed on MySQL
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (14)
As of 2015-07-07 22:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls