Hi all,
Emile wrote:
> LIKE statements? I've used that one before. Not ideal.
;-) That's why I dropped the initial search functions before releasing
Midgard.
Every now and then I've thought about adding an index table to the
Midgard database. The index would be updated automatically every time
the database gets changed or updated. This however is not an ideal idea
as it would have performance and stability problems.
I believe that the best option would be to add an index table that would
be filled by an external application but that would be easily available
to Midgard sites. There could be a separate Midgard indexer that would
read the article records and create the index. Then Midgard applications
could use functions like mgd_search_index(word, word, word, ...) that
would return a set of records that point to articles that contain each
of the words.
I haven't done any deeper research on this issue, but if someone is
interested in working on that, then the index capability would be a nice
addition in the 2.x series.
Jukka
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
