Front end access to a SQL data repository – recommended way?

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:

  1. How close your data is to native WordPress concepts
  2. How much work (if any) it would be required to put it in such representation
  3. 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:

  1. Custom post order when using OR relation
  2. Get Post ID by Content
  3. modify all posts of a category to “no comments allowed”
  4. Ordering Post 2 Post admin meta box by meta from CPT
  5. Add special meta box to custom post type
  6. SQL to update custom post taxonomies
  7. Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
  8. Create Pages from Database
  9. How do I write this SQL statement for Posts written in last 24 hours?
  10. Combine tax_query and meta_query in WP_Query
  11. Query to get the author who having maximum number of post (custom post type)
  12. Query to change custom post type with specific category
  13. Mass convert MySQL data entries into custom post type?
  14. Calculating Bayesian average for custom post type
  15. Query that joins the postmeta table twice
  16. Export entries and multiple custom field meta to .csv?
  17. Deleting Custom Post type data using mySQL command
  18. wpdb custom post_type problem
  19. Adding custom tables to WordPress
  20. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  21. Insert post metadata for all posts in CPT at once if metadata no existent
  22. Convert simple SQL Query to WordPress query
  23. How to Mass Delete Images from Media Library
  24. Including metaboxes from custom post types in global search — continued
  25. Assign External Database Queries to Global Variables and Make Them Accessible
  26. How to import a custom MySQL DB table into a WordPress custom post type
  27. Function causing the loop display posting more (empty)
  28. Order a custom post type admin screen by a second custom post type title
  29. wp_insert_post sometimes fails after API call
  30. Proper way to display latest 5 posts grouped by post type?
  31. Navigate posts with different post type that are in the same categories
  32. How to concatenate two separate colums into one?
  33. Update post if exist from PHP
  34. Custom Search | check multiple meta_value for search value
  35. I’m trying to create a custom version of the wp_list_authors function that includes custom post types
  36. A faster way to query custom post types with multiple conditions?
  37. New post from database
  38. Convert Custom Taxonomy Posts to Normal Posts
  39. How to import database table as custom post type and custom fields?
  40. $wpdb is queried but results don’t show
  41. SQL query – get ids – Advanced Custom Fields / WPeC
  42. Why doesnt my tag page populate with this custom post type?
  43. Fetch data of 2 relational Custom Post in WordPress
  44. SELECT custom post type and its meta in SQL
  45. WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
  46. Custom post type and custom taxonomy key lenght & query performance
  47. Why is this function so slow?
  48. Sql Update CPT from publish to draft and particular custom field
  49. How to transfer categories (default) to custom taxonomy?
  50. Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
  51. Post that populates itself (almost) automatically using data from imported excel file
  52. Populate custom post type/custom fields from an external database
  53. This wp_query will not return any posts and only seems to work with post_status inherit?
  54. Problem with a query in custom posts
  55. Filtering problem
  56. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  57. Assign a tag to custom post type using a query
  58. Query custom fields with three dates – start and end does not work
  59. Exclude objects from WordPress API based from ACF field using rest_prepare_{$post_type}
  60. Limit number of custom posts per taxonomy
  61. Tracking changes in admin-page so user gets warning when leaving the page
  62. Custom taxonomies relationship
  63. filter custom post in rest api with custom function
  64. Get Posts by multiple custom fields is not working
  65. How to change wp prefix for custom post type only?
  66. Single post with a Custom Post Type returns 404, when archives of the CPT work correctly
  67. create a new page from a custom post type similar to an authors page
  68. I want to change the word “Tags” in WordPress to something else, but how?
  69. How to handle paged param in post and custom-post-type?
  70. Set a checkmark in a category based on a URL-parameter
  71. CPT archive admin menu label
  72. Anon function and add_meta_box
  73. Permalinks /country/city/cpt/postname/
  74. Custom Permalink to remove category word , keeping posts permalink with date?
  75. Custom post type ‘articles’ ignores posts_per_page, reserved post_type?
  76. Rewrite Rule for showing Parent/Child Relationship between Two Hierarchical Custom Post Types
  77. Several post types on WP Query by tag and taxonomy
  78. Custom post type – use ajax to display sub pages
  79. Number of Custom Post Types published are not being shown in the custom page
  80. Seamless permalinks between Custom Taxonomy and Custom Posts
  81. Possibilities for the edit.php admin panel? [closed]
  82. Default text in a specific post type, but not visible?
  83. Remove Add Media and all Rich text editor buttons?
  84. Woocommerce custom field search in custom post type [closed]
  85. No Permission to add new Page, Post or CPT with Admin role
  86. Using meta_query and tax_query at the same time
  87. Form action/link to render a plugin in WordPress front-end
  88. Update postmeta Parent when post_status child change
  89. WP Query with categories only shows one post and ignores the category
  90. How to display custom WP menus?
  91. Allow Contributor to edit but not update a published post
  92. Send notifications to custom post author when custom post is edited
  93. Custom post type and custom taxonomy with the same slug using the file page taxonomy only as directory
  94. What to and how to proceed with CPT to make DB small and efficient?
  95. How to display error message in password protected form using ajax jQuery?
  96. Metabox not show in categories custom post type cmb2
  97. What is the best practice for displaying my plugin content in themes?
  98. Categorize custom post type
  99. Content vs Template on custom post
  100. How to Create Columns with WordPress and CPTUI display page ?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)