Search development question
  • Vote Up0Vote Down importimport
    Posts: 0Member
    I'm starting to design a way to do search and I wanted to run some ideas past you folks (Mugor/Holman).

    I was thinking that I want to leverage MySQL's FullText search ability.

    My thinking is this:
    1) Create a Search table with the fields NrArticle, ArticleType, & SearchText
    2) Whenever an article is added or updated I'll will strip out any html from the Multiline WYSIWYG fields and insert or update the article number, the article type, and concatenate all fields from the XTable (based on ArticleType) into our new SearchText field in the Search table.
    3) When a user does a search it will use the FullIndex to search the SearchText field.

    Seems pretty straightforward. Am I missing anything?
Add a Comment