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
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
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