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

Filed under:
|
|

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

Related posts about sphinx

Related posts about index