tag:blogger.com,1999:blog-3300153981717062813.post3841340007198288015..comments2023-10-31T05:08:44.946-07:00Comments on Struggling Developers: MySQL full-text search optimizationPablohttp://www.blogger.com/profile/01339836843089772250noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-3300153981717062813.post-65215764843856265232012-05-16T03:58:32.747-07:002012-05-16T03:58:32.747-07:00Thank you for this. Very useful.
Does sphinx sear...Thank you for this. Very useful.<br /><br />Does sphinx search add much load to the server?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-51695849132422042802010-02-17T14:09:07.658-08:002010-02-17T14:09:07.658-08:00thank you, the information was helpful.thank you, the information was helpful.NMMM.NUhttps://www.blogger.com/profile/03498174084265748638noreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-18968777062374049882008-10-14T15:46:00.000-07:002008-10-14T15:46:00.000-07:00@dominik:I belive that it's possible to have multi...@dominik:<BR/><BR/>I belive that it's possible to have multiple databases on the same config file, because when you define the source (see source 'ads' on my example), you have to specify host, datasource, user and password.<BR/><BR/>I think that if you create a different source for each of your databases with their information on the config file, you could use one instance of Sphinx for all your databases. You just have to specify the source when you perform a search using the API.<BR/><BR/>More info from Sphinx forum:<BR/>http://www.sphinxsearch.com/forum/view.html?id=1255<BR/><BR/>I hope this helps. Thanks for stopping by!Pablohttps://www.blogger.com/profile/01339836843089772250noreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-61646770281053576982008-10-14T07:03:00.000-07:002008-10-14T07:03:00.000-07:00Does Sphinx support searching several different ta...Does Sphinx support searching several different tables? For example, if I run several websites with different databases on the same machine, will I be able to have one search for every site with just one Sphinx installation?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-47107159874194529032008-09-29T06:47:00.000-07:002008-09-29T06:47:00.000-07:00@ellisgl:I think Sphinx is better than DBSight for...@ellisgl:<BR/>I think Sphinx is better than DBSight for a number of reasons. The most important ones are the fact that it's open source and that it provides PHP, Python, Ruby and pure C APIs, which makes it much more flexible.<BR/><BR/>@ben:<BR/>Thanks! I got a huge performance increase. Sphinx performs an average query in under 0.1 sec on 2-4 GB text collections.<BR/>For example, the search by keyword page on my site took like 40 seconds to load with search results and after using Sphinx started to load in 8 seconds.<BR/><BR/>@chris:<BR/>Sphinxs provides a function for updating the index from the API, which you can use to manage deleted records.<BR/>http://www.sphinxsearch.com/doc.html#api-func-updateatttributesPablohttps://www.blogger.com/profile/01339836843089772250noreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-79640081863275225002008-09-28T22:56:00.000-07:002008-09-28T22:56:00.000-07:00How Sphinx deals with deleted records? DBSight can...How Sphinx deals with deleted records? <BR/>DBSight can support finding deleted database records.Chrishttps://www.blogger.com/profile/02784132277981818381noreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-46272090026496928262008-09-26T18:56:00.000-07:002008-09-26T18:56:00.000-07:00Great article! I am really interested to know how ...Great article! I am really interested to know how much of a performance increase you got when using Sphinx.Benhttps://www.blogger.com/profile/15418582545299579229noreply@blogger.comtag:blogger.com,1999:blog-3300153981717062813.post-44140218791091009422008-09-26T09:50:00.000-07:002008-09-26T09:50:00.000-07:00Sphinx does have some limitations thou.. I started...Sphinx does have some limitations thou.. I started to play around with DBSite stuff. It's a Java based Full text search engine that connects to any SQL type DB.Anonymousnoreply@blogger.com