Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

[OT] Re^3: How to improve MYSQL search performance of perl?

by trammell (Priest)
on Aug 19, 2005 at 16:07 UTC ( #485192=note: print w/replies, xml ) Need Help??

in reply to Re^2: How to improve MYSQL search performance of perl?
in thread How to improve MYSQL search performance of perl?

MySQL will choose the appropriate index for the tables involved in your query; in my experience it chooses correctly most of the time. I see from another post in this thread that your query is:
select topic FROM table1 WHERE uri LIKE '$q'
You can find out what indexes are used by MySQL in this query by running the command
EXPLAIN SELECT topic FROM table1 WHERE uri LIKE 'something'
where "something" is one of your parameters. You can see what indexes are defined on your table by running the command

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://485192]
[stevieb]: ...or the proper download link and release page even...
[pryrt]: da39a3ee5e6b4b0d32 55bfef95601890afd8 0709 *strawberry-perl-5 .12.3.0-portable. zip
[pryrt]: matches neither. :-)
[stevieb]: wtf!? lol
[stevieb]: I'm checking some other versions. This is a little frightening
[pryrt]: Sorry, my bad: it was't done downloading when I did the sha1sum... now I match your 309ad... value
[stevieb]: I'll see how to get in touch with someone and advise that there's an issue. Thanks for helping me confiirm pryrt!

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (12)
As of 2017-03-29 21:02 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (353 votes). Check out past polls.