JRMora JSON Search

Description

Default WordPress search relies on heavy MySQL queries using full table scans (LIKE %keyword%). As your site grows with thousands of posts, this process degrades server performance, increases database CPU load, and leads to slow search response times or timeouts.

JRMora JSON Search solves this bottleneck completely by offloading the search process to a lightweight, static JSON file. Upon publishing or updating content, the plugin automatically indexes titles, content excerpts, categories, and tags into an optimized JSON file inside a dedicated /uploads/jrmora-json-search/ directory.

When a user searches on your site, the plugin intercepts the main query, scans the pre-indexed JSON file in milliseconds, and feeds the matched post IDs directly back to WordPress (WHERE ID IN (...)). This bypasses expensive database string comparisons, drastically lowering database load and delivering near-instant search results.

Key Features:

• Database Relief: Eliminates heavy LIKE %...% queries on full-text content across the database.
• Universal Theme Compatibility: Transparently hooks into the default WordPress search loop without requiring template edits or shortcodes.
• Automatic Reindexing: Automatically updates the JSON search file every time a post is published, edited, or deleted.
• Accent & Diacritics Normalization: Strips accents and special characters during index generation and matching, guaranteeing accurate results regardless of search spelling (e.g., matching “Periodismo” with “periodismo”).
• Polylang Compatibility: Built-in support to respect multilingual filtering when using Polylang.
• Performance Banner & Shortcode: Optional performance banner displaying total results count and query execution times, or embeddable via [fast_json_search_stats].
• Manual Reindex Tool: Includes a simple admin settings page to manually rebuild the search index on demand after bulk content imports.
• Clean & Lightweight: Zero external dependencies, no extra database tables, zero background cron bloat, and fully internationalized for localization.

When is this plugin most useful?

• Content-heavy websites, blogs, and digital publications with thousands of published posts.
• Sites experiencing high server CPU usage or database slow-query logs triggered by native site searches.
• Hosting environments with strict database resource limits where un-indexed full-text searching degrades performance.

Copyright

JRMora JSON Search is distributed under the terms of the GNU GPL v2 or later.