Re: [campsite-dev] Search development question
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Hi Tim,

    Sorry for the very long delay; Campsite already has a search engine which is
    not as capable as MySQL's but I'm thinking now whether it's worth to change
    it now, in 3.0 or wait for 3.1. Anyway, your way of thinking is very good
    and if you already did some work we would be happy to accept a patch.

    Please let me know what you think,
    Mugur

    On Jan 19, 2008 7:52 PM, wrote:

    > Author: Tim Smith
    > Link: http://code.campware.org/phorum/read.php?9,6141,6141#msg-6141
    >
    > --------------------------------------------------------------------------------
    >
    > 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?
    >
    > --
    > Sent from Campware Forums
    > http://code.campware.org/phorum
    >
Add a Comment