[ic] Improve speed on retrieving data

[interchange-users@interchange.redhat.com (Jon Jensen)]

On Fri, 11 Jan 2002, Peter Jakl wrote:

> Jon, I think you forgot the attachments.

They came through fine in the mailing I got from the list. I've put copies
here if you can't get the attachments:

http://ic.redhat.com/~jon/custom_search/

> It sounds like this is exactly what I need. I don't believe there's a
> way to optimize the query. We need the ability to do general keyword
> searches such as "color laser printer", etc. I created a single field
> that has the complete list of keywords for each sku. I then do a
> "select sku from products where kw like '%color%' and kw like
> '%laser%' and kw like '%printer%'". If there is a better way within
> the scope of mysql, I'd like to know about it.

Probably Glimpse would be the way to go. It's kind of tricky to set up,
and needs some care and feeding, but very fast for full-text searches once
you get it going.

Jon