MySQL Forums
Forum List  »  Full-Text Search

Problem with FullText
Posted by: Gabriel Sideri
Date: July 13, 2007 10:43PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with FullText
4626
July 13, 2007 10:43PM
3356
August 06, 2007 04:54PM
3063
August 23, 2007 01:20AM
3086
October 03, 2007 11:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.