Questions tagged [Sphinx] (399)

4
answers

Redis vs. Sphinx vs Elasticsearch for storage and search him?

Good day! What do you think is best suited to store data and search them, for example, a product catalog? To meet the following conditions: 1. Storing catalog data with fast access 2. The search for information, especially Russian names requests 3. Easy to use: query syntax documentation 4. The smallest load on the hardwa...
Ona_Bauch asked April 9th 20 at 10:47
2
answers

How to use the OR operator in sphinx?

Use sngrl\need Sphinx $sphinx->search() to find two occurrences of For example $sphinx->search("Test 1' OR 'TEST 2") as this can be done?
Jacquelyn.Strosin39 asked April 8th 20 at 17:25
4
answers

How to organize your pagination if a database and a search engine is a separate services?

Good all the time. How can we arrange pagination query, filtered simultaneously on the full-text query and some arguments, if a search machine for full-text search and the database is separate services? The emphasis is not notice of the decision, although the feeling that it's right. Details: MySQL server (MariaDB 10.3+) ...
leslie.Shiel asked April 8th 20 at 17:15
1
answer

How to implement custom sorting in Sphinx?

Welcome! The bottom line: There is an index of product offerings, which in addition to the basic data for protectora and faceted search are the attributes of the JSON: 1) Attribute with name "similar_from". In this attribute lies the IDs array of similar goods, for which the article is similar. +-------+------------------...
javon_Harber11 asked April 8th 20 at 10:24
2
answers

How to make friends and go Sphinx?

Try to connect to Sphinx to Go on the program using the MySQL driver and get the error commands out of sync. Did you run multiple statements at once? in case of any query. Here is a sample program. In this case, the error returns the method Ping(). The parameter ?multiStatements=true in the DSN string I tried (although the...
rey_Macejkovic asked April 8th 20 at 03:00
1
answer

What's not to like sphinx?

Try to do a search using "OR" in the MATCH. Match to get a possible typo of the word. Looking for 'test search' pre-expelling the possible options. The query looks like trail. way select id, weight() from default where MATCH('test search | EUE wfxr | test search | tеst EAGS'); Get the error index default: syntax error, un...
walter21 asked April 7th 20 at 16:06
1
answer

Smart search on large database. What to choose?

Hello! Looking for ready service to work with a constantly growing database. You need to create a database, where every day will be added ~15k (even more) Planned two scenarios with wheelbase: 1. Add new records: if a row in the database does not exist, then add it to the database. 2. Search the database: - search thro...
Greyson_Ryan42 asked April 7th 20 at 15:22
0
answer

Is it possible in Sphinx sql_attr_multi attribute uint assign zero instead of a blank value from a query?

Suppose there are multi-attribute myattr... ... source catalogSearch { ... sql_query = SELECT ... sql_attr_multi = uint myattr from query; SELECT ... ... } ... If the query from query contains no data for comparison with the sql_query, then Sphinx will put an empty value. Is it possible instead, empty values to re...
Xander_Deckow asked April 7th 20 at 09:41
1
answer

I want sphinx when you update?

Make updating data in rt_index mysql> UPDATE picneco SET title='Title', article='71-1182' WHERE id = 836; I receive an error. ERROR 1064 (42000): sphinxql: syntax error, unexpected QUOTED_STRING near "Title', article='71-1182' WHERE id = 836' What's wrong? Fields and attributes in the index rt_field = item rt_field =...
kathlyn_Tillm asked April 7th 20 at 09:05
1
answer

As in Sphinx select all empty values sql_attr_multi attribute if it is set as a uint?

The index of the Sphinx is the attribute sql_attr_multi uint, which for some records contains a set of numbers as expected, but for the rest of the records it is empty. How to write a query to get the records/rows for which sql_attr_multi uint empty? Below is the query that gives the error unsupported filter type is null o...
Jaden asked April 4th 20 at 13:46