• Full Text Search with Sphinx

    oracle text, context option

    Oracle Text (formerly known as Context Option)

    We are using Oracle Text for full text search. Now that we are using other databases such as DB2, MySQL, etc, we need to consider using the native database API, or standardize on the 3rd party full-text search software.

    We had a look at Sphinx Search. This provides direct APIs to MySQL, and ODBC to other databases. Their most well-known user is Craiglist. Looks very scalable, especially if you can shard the indexes.

    Features we like:

    – Fast-up to 4 times faster than MySQL full-text search.
    – Ability to configure the score, giving more importance to different fields (e.g. weighted fields).
    – Largest web-site using Sphinx handles a database of 4 TB of documents.

    By | 2020-03-27T17:31:39+00:00 8th January, 2014|Insights|

    About the Author:

    The team at JurisTech's Marketing & Communications, a group of digital marketing strategists and content creators, delivers invaluable insights and expertise drawn from fintech experts across the entire JurisTech team. For media queries, get in touch at mac@juristech.net.