Comments on: Sphinx & MySQL: facts and misconceptions https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions Blog by Shlomi Noach Thu, 07 Aug 2014 05:04:16 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-259651 Thu, 07 Aug 2014 05:04:16 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-259651 I did not… And it’s been a while since I last used Sphinx, so I can only assume a lot has gone by that I’m unaware of.

]]> By: Jamie https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-259543 Wed, 06 Aug 2014 17:45:01 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-259543 * Being an external module, it does not update its indexes on the fly. So if 10 new rows are INSERTed, it has no knowledge of this. It must be called externally to re-read the data (or just read the new data), and re-index.

** There’s more than one way to make that less of an issue. I’ll write some more in future posts.

—

Did you end up writing about how to make that less of an issue?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-18994 Thu, 14 Oct 2010 18:30:33 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-18994 @Sachin,
I have no experience with Lucene. From what I gather around, I see many users to both, and I hear they both compete closely in terms of performance and feature set. I can find quite a few links on Google which discuss this; sorry, but I can’t offer any additional information here, other than the fact that Sphinx has a good integration with MySQL, which Lucene does not. This in itself is probably not a sufficient reason to choose one over the other.

]]> By: sachin pethani https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-18992 Thu, 14 Oct 2010 18:01:45 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-18992 HI Shlomi,

Its a grate overview about Sphinx.

Currently I’m using Apahe Lucene’s Solr as “search engine” in my ajax based application.

Is there any difference between these two?

Thanks
http://twitter.com/sachinpethani

]]> By: DmitrySh https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17661 Wed, 15 Sep 2010 21:35:31 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17661 Update: It is not available on a shared hosting account.

]]> By: Kamelot Blog https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17272 Sat, 04 Sep 2010 10:27:17 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17272 Sphinx : j’en dit un peu plus sur ce moteur de recherche…

Présentation de sphinx en français…

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17252 Fri, 03 Sep 2010 12:53:09 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17252 @Nams,
same with other indexes: you need to keep track of the PK where you’ve got the string in the first place. Meaning you’ll need a “real” table to hold the content.

]]> By: Nams https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17251 Fri, 03 Sep 2010 11:58:18 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17251 So how can RT indexes be of complete use if it does not allow string atributes.How can I get my complete document data from mysql table?Any suggestions anyone?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17230 Thu, 02 Sep 2010 19:25:36 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17230 To be sure, this post is not a complete feature list of sphinx (@erkules: thanks).

]]> By: erkules https://shlomi-noach.github.io/blog/mysql/sphinx-mysql-facts-and-misconceptions/comment-page-1#comment-17228 Thu, 02 Sep 2010 18:36:11 +0000 https://shlomi-noach.github.io/blog/?p=2754#comment-17228 The beta also supports “indexes on the fly”
http://sphinxsearch.com/docs/current.html#rt-indexes

]]>