Improve WP Query performance using Sphinx.
| Author: | Casey Bisson (profile at wordpress.org) |
| WordPress version required: | 3.7 |
| WordPress version tested: | 4.0.38 |
| Plugin version: | 0.1 |
| Added to WordPress repository: | 04-11-2014 |
| Last updated: | 04-11-2014
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|
| Rating, %: | 0 |
| Rated by: | 0 |
| Plugin URI: | http://kitchen.gigaom.com/ |
| Total downloads: | 1 014 |
 Click to start download |
|
Sphinx is a blazing fast index of content. This plugin makes it easy get WordPress posts into Sphinx, then query them using standard WP Query. This approach improves the performance of queries in core WordPress and even in plugins without having to implement a new API or rewrite the queries.
See it in use at search.gigaom.com. Each search result is a post in WordPress, Sphinx does the work to find the matching results. The filters in the sidebar are powered by Scriblio based on taxonomy data on each post.
What it accellerates
The plugin accellerates most WP Queries, including search, tag/taxonomy, author, and date, among others. The full list of supported query vars is:
- author
- author_name
- authors
- category__and
- category__in
- category__not_in
- exclude
- feed
- fields
- ignore_sticky_posts
- include
- no_found_rows
- numberposts
- numberposts
- offset
- order
- orderby
- output
- paged
- post__in
- post__not_in
- post_parent
- post_status
- post_type
- posts_per_page
- s
- suppress_filters
- tag
- tag__and
- tag__in
- tag__not_in
- tag_id
- tag_slug__and
- tag_slug__in
- tax_query
- wijax
See those in the code.
What it doesn’t
One of the only class of queries not supported are queries against metadata. Those are ignored by this plugin and WP Query handles those as usual.
go-sphinx automatically detects if other plugins have modified the SQL outside WP Query and steps out of the way if so. That allows the query to execute against the MySQL database as usual, but without the performance benefits of Sphinx.
In the WordPress.org plugin repo
Eventually: https://wordpress.org/plugins/go-sphinx/
Fork me!
This plugin is on Github: https://github.com/gigaOM/go-sphinx