Hi Peter,
Definitely using OR will slow up the performance of FULL TEXT searching.
Instead of using OR, you can try using UNION statement.
Hope this will be a fix for your issue.
Thanks,
ViSolve MySQL Support Team.
----- Original Message -----
From: "Peter Lauri" <[EMAIL PROTECTED]>
To: "'JC'" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Thursday, July 20, 2006 4:21 PM
Subject: RE: FULL TEXT and Asian languages
That is what I am doing right now, but it is not that fast if this system
would grow, and also it is not "ranking" the searches.
Right now I do something like this:
$searchwords = explode(" ", $searchstring);
foreach($searchwords AS $value) {
$Query.= "OR lajlaj LIKE '%$value%'"
}
If there are many search words, the OR will grow a bit, and OR are not
that
fast as I read somewhere.
/Peter
-----Original Message-----
From: JC [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 10:46 PM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: FULL TEXT and Asian languages
don't know about indexing, but try to search: LIKE '%sentences%'
JC
On Thu, 20 Jul 2006, Peter Lauri wrote:
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client.
It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languages. I think this screws up the
indexing, and complete sentences are classed as a word. Assume Thai
characters:
Thisisasentenceinthai. ButIcannotsearchforsentenceinthatsearch.
I want to search for "sentence", but can not. How can this be done? And
will
the indexing ever work?
Best regards,
Peter Lauri
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.2/393 - Release Date: 7/19/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
