Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Empty Query #12

Open
giuseppeauteri opened this issue Jul 26, 2016 · 4 comments
Open

Empty Query #12

giuseppeauteri opened this issue Jul 26, 2016 · 4 comments

Comments

@giuseppeauteri
Copy link

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

@sngrl
Copy link
Owner

sngrl commented Jul 26, 2016

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.

@giuseppeauteri
Copy link
Author

giuseppeauteri commented Jul 26, 2016

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

@sngrl
Copy link
Owner

sngrl commented Jul 26, 2016

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')

@rameezh
Copy link

rameezh commented Aug 3, 2017

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants