MySQL Forums
Forum List  »  Full-Text Search

Re: 4 Minute Full Text Index searches
Posted by: Ueberbach JP
Date: June 24, 2008 06:50PM

use sphinx instead. join the pk's from the result with additional information you might need ( when group by needed ( i.e. showing category hits from current ft search result in desc order ), use synchronized (triggers) memory heap tables containing the values used in the group by ).

Generally, it's a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).

As for the name, Sphinx is an acronym which is officially decoded as SQL Phrase Index. Yes, I know about CMU's Sphinx project.

Options: ReplyQuote

Written By
Re: 4 Minute Full Text Index searches
June 24, 2008 06:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.