rating_imagerating_imagerating_imagerating_imagerating_image

Searching inside LiveFeed

Man with magnifying glassYour 2Yellows MeetingPoint uses MySQL as database. This means that all text (titles, excerpts, body and comments) is stored in one database. To search within this database there are more or less two options. First of all using “regular” search algorithms. These search for the exact presence of words. The downside is that these only search in the title and post body and ginve no relevance/ordening of the results.

Therefor we have implemented a Fulltext search in “natural language mode” in LiveFeed. This means:

  • it gives results faster, because it searches at once, instead post by post;
  • it searches for concepts. So not only exact matches are found, but also relevant matches, for instance company and enterprise. This depends on the content of your MeetingPoint of course and gets “smarter” the more content you have;
  • it uses free text search terms (no “and”, “or” etc necessary);
  • it uses complex and theoretically based relevance and ordening of results. For instance, if a match is found in the article AND in a comment, this will result in a higher ranking of this result.
  • the search generally will be done in the whole database. Except when you are in specific view (for instance a category) when you give the search order. Then only that category will be searched.





Comments »

No comments yet.

Name (required)
E-mail (required - never shown publicly)
URI
Subscribe to comments via email
Your Comment (smaller size | larger size)
:brain: :quote: :cash: :cost: :dont: :todo: :imo: :new: !!! :( :)
You may use <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <img alt="" align="" border="" height="" hspace="" longdesc="" vspace="" src="" width=""> <code> <em> <i> <strike> <strong> in your comment.