How to handle a CSV with 65,000+ rows and make it searchable?

This would be best handled as a custom taxonomy. Why? Because taxonomy is already optimized for finding related content. Using a custom taxonomy means you automatically get post edit metaboxes, archive templates, admin screen searches, and more. Creating posts for each item and using a post_meta search would be orders of magnitude slower. I’m running … Read more

Get unique superset of taxonomy terms from a list of custom posts in another hierarchical taxonomy

Assuming that when you are on the “page” sub_category_1 you’re looking at a standard archive for that term, you can do this… The main query is already for the posts in sub_category_1 so get a list of their IDs: global $wp_query; $post_ids = wp_list_pluck( $wp_query->posts, ‘ID’ ); Then you simply need to get a list … Read more