Re: Once again, three queries, same result, huge speed difference

[Brent Baisley]

It's not the order in which you execute the queries, it's how many 
time. Execute the first one 5 times, then the second one 5 times, then 
the third one 5 times. See if the times are different between each of 
the 5 runs for each query.

Also, you could try reordering your query. Perhaps something like
select <fields> from cds, artists, tracks...
On Dec 4, 2003, at 10:45 AM, Uros Kotnik wrote:

Hmmm, if I execute this 3 queries at any time in any order I get the
same execution time.
Yes, explain...

explain select artists.name , cds.title , tracks.title  from artists,
tracks, cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST ('madonna')
and MATCH (cds.title) AGAINST ('music')
and MATCH (cds.title) AGAINST ('mix')
and MATCH (cds.title) AGAINST ('2001')
| table   | type     | possible_keys          | key            | 
key_len
| ref              | rows | Extra
| artists | fulltext | PRIMARY,name           | name           |       
0
|                  |   1  | Using where |
| tracks  | ref      | PRIMARY,artistIndex    | artistIndex    |       
5
| artists.artistId |   27 | Using where |
| cds     | fulltext | PRIMARY,fulltext_title | fulltext_title |       
0
|                  |    1 | Using where |

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]