[pLog-svn] searchengine

[Mark Wu]

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
>