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: 238
        
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