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. How to get all taxonomies of a post type?
  15. Permalinks: custom post type -> custom taxonomy -> post
  16. How to Add Tags to Custom Post Type?
  17. How come Featured Image isn’t showing up in my Custom Post Type?
  18. Adding ‘menu order’ column to custom post type admin screen
  19. Efficient Taxonomy Intersection
  20. How to create a wp_query that contains both meta_query and tax_query
  21. Display custom post type and custom fields within a Bootstrap Carousel
  22. Notice: map_meta_cap was called incorrectly
  23. Archive page…limiting posts per page
  24. Seperating Custom Post Search Results
  25. WP 3.1 – archive pages for custom content types possible now without a plugin?
  26. Use WP_Query object inside a function
  27. WP_Query search custom posts meta date fields
  28. Pagination go to first page if i’m on last post
  29. Grossly inefficient wordpress loops!
  30. Custom field values get deleted
  31. Pagination throws 404
  32. Include custom post type in “all posts”
  33. How to create a permalink for custom taxonomies and custom post types like base-name/parent-tax/child-tax/custom-post-type-name
  34. Custom Select Query with Custom Post Types
  35. Category and post tag archives do not include posts from custom post type
  36. Displaying different custom post types under one admin menu
  37. Can I change the slug of my archive page on a Custom post type?
  38. Custom Taxonomy – Tags Metabox is showing instead of Categories
  39. How to set up htaccess to redirect a particular post type or subdirectory to HTTPS?
  40. How Can I Set the Post Author of a Post I Just Created With PHP?
  41. Custom Post Type Metabox – Not Saving
  42. WordPress Orderby Numeric Value Not Working
  43. Cherry framework adding custom post type
  44. Include custom post type single template, but respect theme override of template if it exists
  45. How to have custom post type /example/ and then posts /example/posts.html
  46. Multiple Loops On Custom Post Type Template?
  47. Cannot add custom field to “orderby” parameter in Rest API
  48. Not Able to Get Custom Post Type Gallery Images URL
  49. Form action/link to render a plugin in WordPress front-end
  50. Custom post type and custom taxonomy with the same slug using the file page taxonomy only as directory
  51. Building a Treatments Page, What Do I Use?
  52. Multiple Frontend Filters Using Advanced Custom Fields
  53. How do I programmatically create new posts of a custom post type over the XML-RPC API?
  54. Migrating a taxonomy’s tags to the native category
  55. Make custom post types and pages place nice, re: rewrite
  56. How to create subcategory for Custom Post Type?
  57. how to echo meta tag in header using php
  58. PHP question: how to combine syntax?
  59. post_parent in custom post type
  60. Why do I have to press the “Update” button twice to save my meta box values?
  61. How do I add custom HTML to the content of an archive page’s posts?
  62. How to create connection among state, city, store and store number based on URL
  63. How to add query args to links to CPT admin submenu
  64. Templates for hierarchical custom post type
  65. filter by custom taxonomy using ajax
  66. Get post content from another section in custom single page
  67. How to get the current category with custom posts
  68. Modify Posts from Custom_Post_Type within the plugin
  69. Importing JSON feed giving Notice: Array to string conversion error
  70. custom post type: own database table structure and custom “new-post” interface
  71. Custom Post Types and Complex Content Hierarchy
  72. How do I “trash” a custom post type post while logged in as Admin
  73. Pagenavi Plugin and Custom Post Type – Multipage results
  74. Easy-Post-Type is visible in search, but 404 when clicked
  75. custom filtering admin columns
  76. How to display custom taxonomy term specific post?
  77. Limit custom post type to the authors only on front-end!
  78. Remove Header and style.css from Specific Post template
  79. How to remove default modules on single event page on Modern Events Calendar
  80. Show posts from WP Custom Post Type selected from a field in a metabox
  81. WordPress post not executing shortcode until updated
  82. Modify the category post counting function
  83. Post navigation doesn’t show (in custom template, custom post type, custom query)
  84. Keep custom read more link on the same line as excerpt text
  85. Custom Post Type
  86. Force WordPress to only match URL in category
  87. Working with gallery shortcode and get gallery images
  88. Can I create a taxonomy term that mirrors the name of a new custom post?
  89. Ads below footer
  90. Rewrite for custom type and custom taxonomy
  91. Pagination with Custom Post Type
  92. Query child posts on parents single.php?
  93. Show custom post along with default post
  94. Template with Custom Post Type (Custom Tables) does not work
  95. Ordering custom posts
  96. Where do I insert   to? [closed]
  97. WooCommerce – Complete Order when an action occurs
  98. How to debug a 404 error on pages whose content is perfectly displayed when I explore it?
  99. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  100. Remote database access on another wordpress site’s custom post type

Leave a Comment