On 1/4/07, Michael Check <[EMAIL PROTECTED]> wrote:
Second, how to do this technically? With a database that stores questions and answers separately, as text, searching over multiple fields for the same data seems cumbersome - right? Could we store the data as xml files and do blob text searching? Or do keyword storage for each article/question/answer?
Does anyone have experience with using mysql for relevant searching? Apparently, mysql has tools for returning results across multiple tables and fields that can be ranked by relevance according to business rules. I was thinking that by using a correlating mysql database, getting inserts from triggers in the 4D database, we could use these tools to query the questions and answers. We are already using pluggers mysql ext (which is excellent, by the way) and this would be a good use of it. Thanks, Michael Check _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
