{"id":865,"date":"2006-11-23T00:00:00","date_gmt":"2006-11-22T23:00:00","guid":{"rendered":"https:\/\/wwwneu.strehle.de\/tim\/weblog\/archives\/2006\/11\/23\/803\/"},"modified":"2006-11-23T00:00:00","modified_gmt":"2006-11-22T23:00:00","slug":"803","status":"publish","type":"post","link":"https:\/\/www.strehle.de\/tim\/weblog\/archives\/2006\/11\/23\/803\/","title":{"rendered":"Sphinx &#8211; Free open-source SQL full-text search engine"},"content":{"rendered":"<p><a href=\"http:\/\/www.sphinxsearch.com\/doc.html\" title=\"Sphinx - Free open-source SQL full-text search engine\">Sphinx<\/a>Generally, it&#8217;s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data source drivers support fetching data either via direct connection to MySQL, PostgreSQL, or from a pipe in a custom XML format.<\/p>\n<p><strong>Sphinx features<\/strong><\/p>\n<div class=\"itemizedlist\">&#8211; high indexing speed (upto 10 MB\/sec on modern CPUs);<br \/>\n&#8211; high search speed (avg query is under 0.1 sec on 2-4 GB text collections);<br \/>\n&#8211; high scalability (upto 100 GB of text, upto 100 M documents on a single CPU);&#8220;\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SphinxGenerally, it&#8217;s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data source drivers support fetching data either via direct connection to MySQL, PostgreSQL, or from a pipe in a custom XML [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[1],"tags":[],"class_list":["post-865","post","type-post","status-publish","format-standard","hentry","category-weblog"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/comments?post=865"}],"version-history":[{"count":0,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/865\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/media?parent=865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/categories?post=865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/tags?post=865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}