Suggest Sphinx index scheme
Posted
by htf
on Stack Overflow
See other posts from Stack Overflow
or by htf
Published on 2010-05-21T08:41:35Z
Indexed on
2010/05/21
15:40 UTC
Read the original article
Hit count: 203
Hi. In a MySQL database I have documents of different type: some have text content, meta keys, descriptions, others have code, SKU number, size and brand name and so on. The problem is, I have to search something in all of these documents and then display a single page, where the results will be grouped by the document type, such as help page, blog post, item... It's not clear for me how to implement the Sphinx index: I want to have a single index to speed up queries, but since different docs have different structure - how can I group them? I was thinking about just concatenating them, but it just doesn't feel right.
© Stack Overflow or respective owner