sphinxsearch icon indicating copy to clipboard operation
sphinxsearch copied to clipboard

Empty Query

Open giuseppeauteri opened this issue 9 years ago • 4 comments

i need to use sphinx only for filtering using attributes, If i make request using blank query : $sphinx->search("", 'myindex_index') results are always empty. It's normal or is a problem of sphinx.conf configuration?

is possibile make request using blank query field?

thnx

giuseppeauteri avatar Jul 26 '16 05:07 giuseppeauteri

At first Sphynx - a full-text search engine. If you don't need a full-text search in a variety of fields - it's easier to make requests directly to the database, using the desired filter criteria.

sngrl avatar Jul 26 '16 06:07 sngrl

my problem is that my database is big (about 10 milions of record) and query are very complex. So classic search is too slow compared with sphinx approach. With old sphinx api (with php) was possibile and was very convenient.

Thnx for reply. Bye

giuseppeauteri avatar Jul 26 '16 07:07 giuseppeauteri

I can offer only a "crutch" - when you create the index, make an sql-request so that all the texts contained a particular unique word (SELECT "someuniqueword"...), and use it as a search query: $sphinx->search("someuniqueword", 'myindex_index')

sngrl avatar Jul 26 '16 07:07 sngrl

declare this $ObjectName->setMatchMode(\Sphinx\SphinxClient::SPH_MATCH_EXTENDED); before $sphinx->search("", 'myindex_index') If you want to run select query on sphinx

rameezh avatar Aug 03 '17 06:08 rameezh