[pLog-svn] searchengine

[Oscar Renalias]

Maybe we can make it a configuration parameter, so that people can  
enable or disable the usage of fulltext searches? I think the  
performance improvements are too good for western character sets to  
be ignored...

On 2 Feb 2007, at 13:00, Mark Wu wrote:

> Hi Oscar:
>
> Because the MySQL Full Text Search does not work under CJK  
> environment.
> (Even in version) 5.0.x.
>
> We have to implement our own FullText Search and Word Splitter  
> plugin for
> MySQL, If we plan to use it in future version.
>
> That's why we did not use that in previous version.
>
> Mark
>
>> -----Original Message-----
>> From: plog-svn-bounces at devel.lifetype.net
>> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of
>> Oscar Renalias
>> Sent: Friday, February 02, 2007 5:49 PM
>> To: plog-svn at devel.lifetype.net
>> Subject: Re: [pLog-svn] searchengine
>>
>> Jordi seems to have had some success when converting searches
>> from the current LIKE implementation to FULLTEXT indexes and
>> has provided us with a patch.
>>
>> I can't seem to remember why we didn't go with FULLTEXT in
>> the first place... I know there was a reason not to, but I
>> can't remember why.
>> I will take a look at the code and see if all searches can be
>> changed to FULLTEXT in 1.2.
>>
>> On 2 Feb 2007, at 03:08, Jordi Salvadó wrote:
>>
>>> Hello,
>>>
>>> Sorry but my English is bad. Please Oscar translate me.
>>>
>>> ----------------
>>>
>>> He investigat perquè les cerques anaven tant lentes a bloc.cat.
>>> Últimament gairebe mai era capaç d'acabar cap petició de cerca en
>>> exit, totes trigaven infinitat de segons ....
>>>
>>> He vist que per cercar no es fan anar els indexos FULLTEXT.
>> I fins hi
>>> tot es fan diverses consultes.
>>> No acabo d'entendre com es que no els feu anar, potser teniu algun
>>> motiu que desconec.
>>>
>>> He fet uns canvis al searchengine.class.php i les cerques ara són
>>> instantanees.
>>> Adjunto el fitxer tal cual, amb les linies anteriors
>> comentades i les
>>> meves propostes.
>>> Se li haurien de fer uns rectocs. Nomes he canviat les cerques
>>> d'articles però suposo que es pot fer extensible a molts
>> més llocs del
>>> codi.
>>>
>>> He fet anar "IN BOOLEAN MODE" que només es compatible amb MySQL 4,
>>> però es pot treure tranquilament que gairebé fa el mateix i llavors
>>> funciona amb mysql 3.x
>>>
>>> A veure si us serveix. Si us agrada la idea puc mirar de substituir
>>> totes les cerques tipus LIKE (% %) per aquestes MATCH ...
>> AGAINST molt
>>> millors.
>>>
>>>
>>> Salut !
>>> <searchengine.class.php>
>>> _______________________________________________
>>> pLog-svn mailing list
>>> pLog-svn at devel.lifetype.net
>>> http://limedaley.com/mailman/listinfo/plog-svn
>>
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://limedaley.com/mailman/listinfo/plog-svn
>>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>