sphinx

I have a question that , i use the index by the mysql database itself to index is better or using the index function in sphinx index.

I am executing the following query with JDBC/SphinxQL (Sphinx version 2.01 Beta) ResultSet res = stmt.executeQuery("SELECT * FROM myindex WHERE…

I am using the SphinxQL MySQL client which stores indexes as "tables" but has no real notion of a "database"...One specifies the port (9306 in my…

So learning Sphinx Im now understanding how to setup indexes and updating them. The problem is deleted entries. I plan to use delta indexes but it…

Interested in using Sphinx for my application. Planning to install their latest version which is 2.x. Then use the Sphinx php api. My question is, I…

I'm using sphinx to find images by description, but I'm having trouble with short and too common words like 'the', which don't have an useful…

I need some help on Sphinx MySql index group by. I have a product table where I have product ids and corresponding retailer ids. What I want to do…

Hi, I have a mysql database table that contains multiple records of: "word-A" -- "words related to word-A" For example: chair --…

I have been trying to figure this out for the past day and figure it is an easy question for those who know Sphinx. I have Sphinx installed at…

Good time of a day! I have: Windows 2008 web server edition with big mvc project Another dedicated MySQL server (Ubuntu Linux) with Sphinx engine…

Hi there, I have installed Sphinx successfully on my system but it giving me "ZeroDivisionError" every I search with right keywords. If i search…

For those who have previously worked with/know how they work, which one of the aforementioned IR is easier to learn how to work with and to…

Hi, I'm using Sphinx and ThinkingSphinx gem with Rails 3 for searching. I want to search for exact match of a certain string for an sphinx-indexed…

group by and count doesn't work in sphinx search v 2.0.1B, why? mysql> select count(*) from my_index group by myattr; ERROR 1064 (42000):…

Hi! We're on Rails hosted by Heroku. I'm not a great dev and haven't had experience with Solr or Sphinx. We have a Postgres db and some documents,…

I have sphinx installed for my search engine, and it works great, but now I'm trying to add a few extra features to the search using setFilter()…

Hello, I'm looking sphinx and discovered a way to set up filters by one or more criteria. I'll get a database of recipes. In the pastry, I have a…

I have to deal with queries that have lots of results, but I only show them in sets of 20-30 rows. Then I use the SetLimits() method from the php…

All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still…

All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still…