Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/styllloz/public_html/qa-include/qa-base.php on line 1175

Warning: session_start(): Cannot start session when headers already sent in /home/styllloz/public_html/qa-include/app/users.php on line 162

Warning: Cannot modify header information - headers already sent by (output started at /home/styllloz/public_html/qa-include/qa-base.php:1175) in /home/styllloz/public_html/qa-include/app/users.php on line 1267

Warning: Cannot modify header information - headers already sent by (output started at /home/styllloz/public_html/qa-include/qa-base.php:1175) in /home/styllloz/public_html/qa-include/app/page.php on line 356
Sphinx or Yandex.Server? - | Q&A

Sphinx or Yandex.Server?

Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
Actually a subject. A lot of text(4000 thousands of articles, 8 million).

Spinning all using mysql on linux 2.6.

Interested in how both products cases memory consumption and the quality of issuance.
by | 15 views

4 Answers

0 like 0 dislike
4000 or 4,000,000 for articles?
You can put both.
Yandex server capricious in settings and heavier with the documentation. A year ago there was a problem with the encoding when indexing via mysql, as it managed to get around.
But there are also bonuses, in particular the finished results with light. For a small number of documents Yandex perhaps convenient. The main difference — Yandex when searching saves you from extra access to the database of documents.
The Sphinx is much simpler rises, documentation, no problem (live forum) and more flexible in settings.
For really big databases Sphinx will give hundred points forward to a third because of the ability to store a large part of the base on the screw ( the direct problem ).
the lack of the Sphinx in the need to climb into the sql database handles during the international search (in the latest beta have the opportunity to store the sample in the base of the Sphinx, but it and betka to be uncomfortable. on small databases usability, in large — inhibits).
Living examples: on the basis of the orders of magnitude of hundreds of millions of records have been selected the Sphinx. Yandex stupid couldn't survive on one machine (have not found it a mode that allows you to minimize the amount of memory).
0 like 0 dislike
Sphinx, Yandex.The server is very picky about the OS and settings (kuuucha spent time on his zapilivanija)
0 like 0 dislike
I do not remember, whether there is at Yandex.the server can index the database itself, in contrast to the Sphinx. Afaik it only http crolet and files on the screw can preindexing. behind this warning is easier to set the Sphinx at the base or Yandex.the server on the website.
in General, it depends on what you actually want to index the page or column in the database table, and then screw that will fit.
something like this. a couple of times Yandex.the server is set, any difficulties I do not remember. the Sphinx did not put, I can not compare.
0 like 0 dislike
In J. monoadesivi With database MySQL and any other ODBC.
Raised and the Sphinx and Ya, of course Ya have relevance With the above, but he takes too long to index the site from 450,000 pages approximate time — 2 hours, and during indexing he needs 2 gig on the screw that was free(number of pages). And when he starts to merge the indexes, the server is hung up, the host complained constantly that my server eats more operatives than you(2giga). In short, You decide, but with 4M articles I would if put With Ya, on a separate server.

Related questions

0 like 0 dislike
3 answers
asked Apr 11, 2019 by kovalenko_jul_s
0 like 0 dislike
4 answers
0 like 0 dislike
1 answer
asked May 20, 2019 by ortsuev33
0 like 0 dislike
2 answers
asked May 10, 2019 by andrei2019
110,608 questions
257,186 answers
35,182 users