Charset and French Diacritic Characters

2003-01-25 Thread Xavier LENOIR
What should I do to obtain that the queries are insensitive to french characters ? Any help will be appreciated ! Best Regards ! Xavier LENOIR - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Slooooow Performance with Full text index

2002-10-15 Thread Xavier LENOIR
index when there is a lot of matching rows ? Why performance depends on the number of results ? I suppose that the problem is due to the fact that MySQL automatically sorts (by relevance) all the results collected before producing the first 10 ? What can I improve performance significantly ? A

HELP : Performance with FULLTEXT Index

2002-10-14 Thread Xavier LENOIR
s), it takes more than 35 seconds... I have supposed that the problem is due to the fact that MySQL automatically sorts (by relevance ?) the results collected... So, I try to add a "LIMIT 10" to the SELECT... but it does not change anything at all... Any idea ? I re