|
|
|
| laziness, impatience, and hubris | |
| PerlMonks |
Re: Optimizing a MySQL Queryby Cine (Friar) |
| on Aug 23, 2001 at 02:02 UTC ( [id://107164]=note: print w/replies, xml ) | Need Help?? |
|
In general, what you do is use the functions in mysql that tells you what the database will do with your query. See
DESCRIBE SYNTAX. This will almost always tell you where you need a good index and also possible give you a hint of what to do with the query to make it faster.
T I M T O W T D I
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||||||