I've recently been doing a lot of work on keyword searches. The methodology I've adopted consists of generating a list of keywords based on the product information (while removing noise words), and creating a table with one keyword per line, relating to the product ID (many rows per product). The keyword search runs off of the keyword table, and no keyword specific information is stored in the product table.
In my experience, there are a couple of downsides to this way of handling it. For example, complex keyword queries (in my case, 4 or 5 specific words) start taking a long time to run, around 5-10 seconds on a 15,000,000 row keyword table (since I have to join the table with itself). I also am not doing any kind of substring searching, it only matches whole words. I haven't even begun to look at doing a fulltext search on a description field, I've assumed that it would be a more expensive operation. Good luck, and I'd like to hear if you run into any good ideas. On Fri, 10 Sep 2004 14:26:22 -0500, Robb Kerr <[EMAIL PROTECTED]> wrote: > Anyone created one? I've got a project that consists of a product catalog > which the client wants to be "keyword" searchable. I have thought through > several possible construction scenarios... > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
