Are custom post types suitable for storing high numbers of data elements, in this case chat messages?

As far as I can see, the main problem you might have to deal with is having to store a fairly large amount of chat messages.

So to avoid making WP core functionalities querying post and postmeta from large amount of rows generated by your single functionality, it seems obvious to me you’d better create a custom table.

I believe this would also offer to you the possibility to optimize your table’s structure for your specific usage which would result in faster queries.

At this time, WP postmeta queries get very slow generally speaking, when they have to deal with a large amount of rows.
Look at the problem WooCommerce actually has when dealing with over 100k products which they store as post and postmeta. They’re on the way of fixing this by migrating all the products inside custom tables…

Related Posts:

  1. Where are wordpress custom types stored?
  2. update a post meta from a single table cell TablePress
  3. update custom post type meta from a shortcode
  4. Save custom post type in different table
  5. How to handle a CSV with 65,000+ rows and make it searchable?
  6. Modification of how the data is controlled/showed and stored
  7. Is it a good idea to add a column to the posts table?
  8. Custom Columns for Custom Post Type Manager
  9. Clone wp-admin/users.php (Users Admin Page)
  10. Right way to store a large set of similar information on website? [duplicate]
  11. How to use TOC with ACF?
  12. Loop posts in a table ordered by a custom field value
  13. What is the most efficient way to manage changes my product comparison tables?
  14. Advanced search form with filters for custom taxonomies and custom fields
  15. WordPress 3.3 custom post type with /%postname%/ permastruct?
  16. Show Custom Taxonomy Inside Custom Menu
  17. Have different search results template depending of custom post type searched
  18. Why does a custom post type need the ”hierarchical’ args setting?
  19. WordPress REST Create Post of Custom Type
  20. How do I programmatically add items of content to a custom post type?
  21. Created a custom post type- can’t view it
  22. Merging two Custom Post Types into one
  23. is_singular won’t call my functions?
  24. Group search results by post type, but hide post types with no results
  25. Custom Slug for a custom post type and default post
  26. same archive template for different custom post
  27. how to set default value for checkbox in wordpress
  28. How do I Use Nested Loops of Custom Post Types for MultiSite Blogs using WP_Query()
  29. Page naming when there is a sub-category only sometimes.
  30. Remove Taxonomy Slug when No Taxonomy is Assigned to Custom Post Type?
  31. Impossible to get Attachments Outside WordPress?
  32. How to Display ACF Relationship Custom Field as Link to Specific Custom Post?
  33. Taxonomy Templates
  34. Pagination on Custom Post Type: 404 Error
  35. Is it possible to create a shortcode that will query a post based on taxonomies?
  36. How can I show/add/save custom metaboxes as an Array of values?
  37. Query Multiple Meta Values and display only when it has both meta values
  38. Query custom post type in the loop
  39. Custom Post Types – Change order of menu items
  40. What template files do I need to customise custom-category-term-links rather than fall back on archive.php?
  41. get the custom post type title/name
  42. Custom post types as sub menu pages and role capabilities issue
  43. Troubles with acf/save_post and WP_Query
  44. Query custom post type with ACF Date
  45. Add custom field in comments form
  46. WordPress request fiter order by related post’s post_title
  47. Need help with permalink rewrites for Custom Post Types with hierarchical relationships
  48. Best method to make posts searchable, sortable and filterable – custom field, tag or category?
  49. Custom post with more than one custom taxonomy
  50. Shortcode for CPT post content in a page
  51. How to use manage_$post_type_posts_columns with underscore in post type?
  52. Custom Post Type Category Link
  53. Custom Post type category pages template and loop
  54. Custom templates for a specific category
  55. How to automatic update date and time when save custom post type
  56. get_the_tag_list() returns bad links
  57. Filter second dropdown (tax) based on first dropdown (cpt)
  58. Excluding a Custom Post Type with a specific tag using pre_get_posts
  59. Merge page with custom post type
  60. Inefficient Query Confusion
  61. What is the diference between Post Metadata and Queried Object
  62. REST filters only firing when I have a param set
  63. WordPress custom post type and taxonomies
  64. Search for dates on custom post types
  65. list posts of two post types in a single template
  66. Multiple post types for BuddyBlog plugin [closed]
  67. Custom Post Type Date Based Archive URL rewrite [duplicate]
  68. Conflict in function to allow single post template based on category
  69. How to display “Trash” in my custom post type?
  70. Sort custom posts by date and then by taxonomy
  71. Add a form in every post and save data in post meta
  72. Custom post type sortable columns when column value is from a custom database value
  73. Plugin Development using classes – Public & Private Callbacks
  74. Correct way adding External classes to Custom Post type and output their methods to template
  75. Linking WordPress Post Types to Another
  76. Migration in new Custom-Post-Type-Structure
  77. Get posts in custom post type categories
  78. Rest Api not working with Iframe in form data
  79. is using “require_once” in wordpress theme affect the speed ???
  80. Getting Custom Posts with Custom Taxonomy
  81. Custom Template for CPT Categories
  82. How to redirect CPT permalinks from ID to default pretty permalinks?
  83. Custom Taxonomies in body class with parent slug
  84. Multiple archives for cpt, taxonomies, terms
  85. How to pass taxonomy terms to WP_Query along with $args?
  86. Display custom Taxonomies same as listing Categories
  87. Show all post of a taxonomy with one specific term not working
  88. Can you get the themes options page to turn on/off which custom post types are registered?
  89. Thumbnails for custom post not showing up in query
  90. custom post types, pre_get_posts, wp_list_categories
  91. WordPress nested loop not working
  92. next_posts_link returns same content of 1st page
  93. Cant we use a PHP file directly like myhome.com/some.php?
  94. Post type cloud like tag cloud?
  95. Is this the correct way to add post-slug input field?
  96. Are there established patterns for developing custom post types?
  97. Determine category in taxonomy of current custom post type
  98. Create settings page to enable or disable CPT
  99. Drawbacks of making the default post-type: post hierarchical [closed]
  100. Show category only if post type is post_three

Leave a Comment