Super Speedy Listings changelog

Category, tag, brand and author archives that stay fast as the catalogue grows

Latest version3.1.2

Tested up toWordPress 6.4

3.1.2

Table upkeep now runs only for a caller entitled to make the edit, so it can no longer be triggered by visitors or by logged-in users without permission to edit the content
Added an AJAX authorisation test suite under .tests

The archive table now indexes every post status, so archives and REST listings viewed by logged-in editors include private and draft content correctly
Posts with no terms and post types without taxonomies, such as pages, are now included in the table, completing author archives
Fixed tax_query with multiple taxonomies under an AND relation returning posts matching only the first condition
Fixed tax_query with an OR relation returning no posts
Fixed NOT IN exclusions such as tag__not_in returning no posts
Fixed posts_per_page -1 and nopaging listings capping at the default page size
Fixed menu_order, post_date and post_modified clearing in the archive table after a post edit
Archive pages no longer repeat posts when many posts share the same date, an issue that affects stock WordPress pagination
post_title ordering now compares the first 255 characters instead of 100
SSTR_DEBUG now defaults to off
Composite indexes rebuilt around post type, status and taxonomy for faster archive queries
Updating requires a full table rebuild: run wp ssl build or use the rebuild button in the settings tab
Added regression, integrity and content-lifecycle test suites under .tests

Renamed to Super Speedy Listings (formerly Super Speedy Term Relationships)
Now loads as an add-on of either Scalability Pro or Super Speedy Filters - whichever parent plugin is active loads the archive optimisation code and settings tab
Registers with Scalability Pro via the spro_register_addons filter (Archives tab) and with Super Speedy Filters via ssf_register_addons (Performance tab)
Existing sstr_object_ancestors table, settings and CLI commands are unchanged (internal SSTR_* names kept for backward compatibility)

Added post_author query optimization - rewrites author archive queries to use the object_ancestors table
Author queries selecting .ID bypass wp_posts entirely via FROM table swap
Author queries selecting .* use subquery optimization: filtering and deduplication on the indexed sstr table, then JOIN to wp_posts only for the small paginated result
Fixed taxonomy optimization to only eliminate wp_posts when fields is .ID (not .*)
Added dedicated indexes for author queries (ixPostAuthorQuery, ixPostAuthorCount)
Added wp sstr rebuild CLI alias for wp sstr build
Added SSTR_DEBUG mode for HTML comment debug output

Added post_status, post_parent columns to object_ancestors table
Query optimization now eliminates wp_posts table entirely when all referenced columns exist in object_ancestors
Rewrites FROM clause to read directly from object_ancestors, removing JOIN to wp_posts
Removes unnecessary GROUP BY and DISTINCT when no JOINs remain
Significant performance improvement: taxonomy queries drop from ~0.7-0.9s to ~0.012-0.02s

Full rewrite with WP-CLI support, admin interface, and incremental table maintenance
Added configurable columns and meta ordering keys
Background processing for table builds