>
> Hi folks!
>
> I'm sorry to bother you with this question which is not a specific midgard
> question. But it is a part of a midgard project I'm working on.
>
> Is there a good tool around for indexing a table in MySql for free text
> search?
>
> I really need a search engine that can make my users able to do a free text
> search in my database. I have 200.000 records, so a query like
>
> SELECT * FROM table WHERE content LIKE '%searchtext%'
>
> goes really slow.
>
> Please help me out here!
>
You basicaly have two solutions:
1) you get MySQL 3.23 and manualy add FULLTEXT indexes this will give
you average speed indexing & query, but for 200 000 records I
guess it can work. You can't have boolean search (vector space
model). Speed and boolean operators are being improved/added as I
speak but you can't expect a full fledged index/search to be
available before MySQL 4.0 is out. i18n is limited to what
MySQL provides but this matches Midgard standard and should
not be a problem for you.
2) you get mifluz (http://www.gnu.org/software/mifluz/) which is
a full text indexing *library* (C++) and you write the necessary
piece of software to bind it to Midgard. I will eventualy
work on this but you can't expect it to work properly before
a few month time.
I hope this help,
--
Loic Dachary http://www.dachary.org/ [EMAIL PROTECTED]
24 av Secretan http://www.senga.org/ [EMAIL PROTECTED]
75019 Paris Tel: 33 1 42 45 09 16 [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
