In typical use cases the performance cost of booting WordPress core for page load is significantly higher than querying for data. In other words it doesn’t quite matter, because it won’t be a bottleneck.
You have to estimate:
- How close your data is to native WordPress concepts
- How much work (if any) it would be required to put it in such representation
- How complex queries it would need for data retrieval
Against making custom SQL table. This cannot be done in general, only for specific case and data. The closer it is to what WP typically handles the more you will benefit from native API and caching mechanisms. But for data that is considerably different in nature separate storage might very well make more sense.
Related Posts:
- Custom post order when using OR relation
- Get Post ID by Content
- modify all posts of a category to “no comments allowed”
- Ordering Post 2 Post admin meta box by meta from CPT
- Add special meta box to custom post type
- SQL to update custom post taxonomies
- Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
- Create Pages from Database
- How do I write this SQL statement for Posts written in last 24 hours?
- Combine tax_query and meta_query in WP_Query
- Query to get the author who having maximum number of post (custom post type)
- Query to change custom post type with specific category
- Mass convert MySQL data entries into custom post type?
- Calculating Bayesian average for custom post type
- Query that joins the postmeta table twice
- Export entries and multiple custom field meta to .csv?
- Deleting Custom Post type data using mySQL command
- wpdb custom post_type problem
- Adding custom tables to WordPress
- $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
- Insert post metadata for all posts in CPT at once if metadata no existent
- Convert simple SQL Query to WordPress query
- How to Mass Delete Images from Media Library
- Including metaboxes from custom post types in global search — continued
- Assign External Database Queries to Global Variables and Make Them Accessible
- How to import a custom MySQL DB table into a WordPress custom post type
- Function causing the loop display posting more (empty)
- Order a custom post type admin screen by a second custom post type title
- wp_insert_post sometimes fails after API call
- Proper way to display latest 5 posts grouped by post type?
- Navigate posts with different post type that are in the same categories
- How to concatenate two separate colums into one?
- Update post if exist from PHP
- Custom Search | check multiple meta_value for search value
- I’m trying to create a custom version of the wp_list_authors function that includes custom post types
- A faster way to query custom post types with multiple conditions?
- New post from database
- Convert Custom Taxonomy Posts to Normal Posts
- How to import database table as custom post type and custom fields?
- $wpdb is queried but results don’t show
- SQL query – get ids – Advanced Custom Fields / WPeC
- Why doesnt my tag page populate with this custom post type?
- Fetch data of 2 relational Custom Post in WordPress
- SELECT custom post type and its meta in SQL
- WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
- Custom post type and custom taxonomy key lenght & query performance
- Why is this function so slow?
- Sql Update CPT from publish to draft and particular custom field
- How to transfer categories (default) to custom taxonomy?
- Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
- Post that populates itself (almost) automatically using data from imported excel file
- Populate custom post type/custom fields from an external database
- This wp_query will not return any posts and only seems to work with post_status inherit?
- Problem with a query in custom posts
- Filtering problem
- Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
- Assign a tag to custom post type using a query
- Renaming Custom Post Types and Taxonomies
- Mixing regular and custom post types (with meta_query) on home page
- Custom post type support for get_users(‘orderby=post_count’);
- Adding custom post type to loop
- specify meta_key / meta_value condition for prev_post_link and next_post_link
- Debug output during filter execution doesn’t work
- Disable adding of new post (custom post type)
- Taxonomy posts on Archive page
- No results searching custom post type in admin panel
- How to modify archive query with pre_get_posts to append CPTs?
- How can I auto-assign a CPT post to category in a custom taxonomy when published?
- Mapping Subdomains in WordPress to give the appearance of a localised site, best approach?
- What is the recommended / best way to do this: Event calendar post/type in a block-based theme?
- How do I run SQL queries on a WordPress web page? [closed]
- Categorize custom post type
- Polylang non-default language ignores tags in WP_Query
- WP-API select custom taxonomy when creating a post
- Breadcrumb Not Linking to the Correct Custom Post Type Index Page(s)
- List of Posts and Categories
- Add a permalink variable onto custom post type URL after post name slug
- Show only public custom posts in home page
- Only show posts with a specific term of an associated taxonomy in a custom post type archive
- Variable Products as custom post types
- Grab all Custom Posts by multiple taxonomies and terms
- If custom taxonomy else conditional [closed]
- updating one custom meta field only
- Custom Taxonomy Archive generates 404
- How to hide private posts even if user is admin
- Support for author does not show author column in post table in dashboard
- How to make sure, that only the selected post is changing?
- How to make a custom search template for custom taxonomy?
- How to retrieve custom post type permalink in another cpt?
- Retrieving custom post type fields without a post
- Custom Post Status & Taxonomies
- pre_get_posts with multiple post types AND a meta_key
- custom post type for custom talbe
- Post being scheduled that shouldnt be schedulded
- Custom Post Type and Taxonomy pagination permalink
- Author template – separate custom post type by custom taxonomy term for $curauth
- Dealing with variables with gettext function
- how do I create a breadcrumb to work with multiple custom taxonomies
- A call to list all Custom Post Types?
- Custom Post Type urls not working