Let\'s say I have a 1:many relation: Tree:Apples Tree/Apple each have an primary key ID column and apple has some date attribute/column (created_at).
I have followed the sphinx manual here:http://sphinxsearch.com/docs/current.html#delta-updates on how to perform delta updates to your index.
I am curious as to whether or not Sphinx will auto update its index when you add new SQL data or whether you have to tell it specifically to reindex 开发者_StackOverflow社区your db.
In my mysql db I have a user table consisting of 37,000 (or thereabouts) users. When a user search for another user on the site, I perform a simple like wildcard (i.e. LIKE \'{name}%}) to return the
I installed Sphinx search on debian squeeze. Connection trough the mysql client, with : mysql -h127.0.0.1 -P 9306 开发者_运维问答--protocol=tcp
If I update a resource in my sphinx.conf file I can reindex with --rotate and everything works fine. If I update an index in my sphinx.conf or add a new index --rotate has no effect and I have to res开
I\'m trying to filter by date the queryset that Django-sphinx returns but I am always getting the queryset unfiltered.
Im making a dynamic CMS, so every instance of the CMS will have its on tables in one MYSQL DB. So far all is working.
I\'m trying to install Sphinx search server with pgsql and I have this error: \"unknown type \'pgsql\'; skipping;\"
I really need help installing Sphinx and getting it going. I\'m on rails 3 and I\'m following these set of directions: http://freelancing-god.github.com/ts/en/quickstart.html to install Sphinx.