Problem with FullText
Hi friends, It's my first Topic. I'm From Argentina and my english is poor.
I have a database with 1.000.000 registers, for a Lyrics Songs site.
For control, I have 2 tables:
1st Table
Artists
ID | Artist_Name
2nd Table
Lyrics
ID | Title_Lyric | Lyric | ID_Artist
Where the row ID_Artist in table (Lyrics), is connecting with te row (ID) in the 1st Table (Artist). Can you Understand me?.
I created a Fulltext index in the row Lyric(second table).
The problem is, when I want to Find for first time, for example the phrase "love of my life, you hurt me", The server is so late.
But when I find for second time, the same phrase, the server is so fast.
I need that the server be Fast everytime.
For this work, I use the following Mysql sentence:
SELECT
Artists.Artist_Name, Lyrics.Lyric,
Lyrics.Title_Lyric, Lyrics.ID,
MATCH (Lyrics.LETRA) AGAINST
('love of my life, you hurt me') AS pointer
FROM Lyrics inner join Artists on Lyrics.ID_Artist = Artists.ID
WHERE MATCH (Lyrics.Lyric) AGAINST
('love of my life, you hurt me')
Do you have idea? I am lost, and in the spanish forums, I dont take help..
Best Regards
Gabriel
Argentina
Pd: Sorry for my englihs.