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

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

Hi,

Many many thanks for that great article but a question just poped up after reading. It says that mySQL will build indexes for the whole table when calling "CREAT TABLE ....." I suppose it means that I don't need to rebuild an index (my table only has two columns). Ok, even I rebuild an index by myself, how it can be used?

Thanks again,

Nan

Comment on Re^2: How to improve MYSQL search performance of perl?

Replies are listed 'Best First'.
[OT] Re^3: How to improve MYSQL search performance of perl? by trammell (Priest) on Aug 19, 2005 at 16:07 UTC
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'` [download] 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'` [download] where "something" is one of your parameters. You can see what indexes are defined on your table by running the command `SHOW CREATE TABLE table1;` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

[OT] Re^3: How to improve MYSQL search performance of perl?
by trammell (Priest) on Aug 19, 2005 at 16:07 UTC

select topic FROM table1 WHERE uri LIKE '$q'
[download]

EXPLAIN SELECT topic FROM table1 WHERE uri LIKE 'something'
[download]

SHOW CREATE TABLE table1;
[download]

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom