Is it possible to use Sphinx search with dynamic conditions?

Posted by Fedyashev Nikita on Stack Overflow See other posts from Stack Overflow or by Fedyashev Nikita
Published on 2010-05-19T09:57:12Z Indexed on 2010/05/19 10:00 UTC
Read the original article Hit count: 240

Filed under:

sphinx

|

full-text-search

|

thinking-sphinx

|

ultrasphinx

|

mysql

In my web app I need to perform 3 types of searching on items table with the following conditions:

items.is_public = 1 (use title field for indexing) - a lot of results can be retrieved(cardinality is much higher than in other cases)
items.category_id = {X} (use title + private_notes fields for indexing) - usually less than 100 results
items.user_id = {X} (use title + private_notes fields for indexing) - usually less than 100 results

I can't find a way to make Sphinx work in all these cases, but it works well in 1st case. Should I use Sphinx just for the 1st case and use plain old "slow" FULLTEXT searching in MySQL(at least because of lower cardinality in 2-3 cases)?

Or is it just me and Sphinx can do pretty much everything?

© Stack Overflow or respective owner

Related posts about sphinx

Sphinx PHP search

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm doing a Sphinx search but turning up some really weird results. Any help is appreciated. So for example if I type "50", I get: 50 Cent 50 Lions 50 Foot Wave, etc. This is great, but when I search "50 Ce", I get: Ryczace Dwudziestki Spisek Bernhard Gal Cowabunga Go-Go And other crazy results… >>> More
sphinx xmlpipe2 cassandra and ruby 1.9

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I start to using cassandra and I want to index my db with sphinx. I wrote ruby script which is used as xmlpipe, and I configure sphinx to use it. source xmlsrc { type = xmlpipe2 xmlpipe_command = /usr/local/bin/ruby /home/httpd/html/app/script/sphinxpipe… >>> More
Sphinx PHP Geodist problems

as seen on Stack Overflow - Search for 'Stack Overflow'
Below is my PHP function to call nearby points using Sphinx for MySQL. There are hundreds of thousands of nearby points which to what I can tell, are being indexed by Sphinx, but simply fails silently when searching with Sphinx. Other Sphinx queries I run against other indexes work completely fine… >>> More
Problem running Thinking Sphinx with Rails 2.3.5

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I just installed Sphinx (distro: archlinux) downloading the source. Then I installed "Thinking Sphinx" plugin for Rails. I followed the official page setup and this Screencast from Ryan Bates, but when I try to index the models it gives me this error: $ rake thinking_sphinx:index (in /home/benoror/Dropbox/Proyectos/cotizahoy) Sphinx… >>> More
django error ,about django-sphinx

as seen on Stack Overflow - Search for 'Stack Overflow'
from django.db import models from djangosphinx.models import SphinxSearch class MyModel(models.Model): search = SphinxSearch() # optional: defaults to db_table # If your index name does not match MyModel._meta.db_table # Note: You can only generate automatic configurations from the ./manage… >>> More

Related posts about full-text-search

Error while configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
Configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
How to customize the full text search ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Full text search is becoming a tedious job using the relational databases’ approach. Can anybody suggest an alternate option if any or way to customize the full text search ? >>> More
WHoosh (full text search) index problem

as seen on Stack Overflow - Search for 'Stack Overflow'
iam having the following problem with whoosh full text search engine. 1.After syncdb i am creating the intial index from the database objects. 2.it is working fine.I can able to search the data and see the results. 3.after that in one of my view i have added another document (via signals) to the… >>> More
How to implement full text search in Django?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to implement a search function in a django blogging application. The status quo is that I have a list of strings supplied by the user and the queryset is narrowed down by each string to include only those objects that match the string. See: if request.method == "POST": form… >>> More