So the only reason you want to re-architect WordPress to use multiple tables for different post types is because your posts table is getting bigger too fast? I assume the underlying issue for you is that performance is suffering?
Instead, I suggest adding appropriate indexes to the post table for the queries you are finding unacceptably slow. This will be a whole lot easier and you won’t have to have a nonstandard version of WP to deal with for everythi.g else you want to do.
Here’s one reference to help with indexing.
Related Posts:
- Reusing old post IDs
- When is the ‘post_content_filtered’ column in database cleared by WordPress?
- Optimize post insert and delete for bulk operations?
- Can posts have parents?
- Where is the old post permalink slug stored?
- How can I safely increase the character limit for post passwords?
- Restore contents of deleted user
- How are terms connected with posts in database?
- Moving WordPress to new server: no posts found
- Custom Taxonomies Incorrectly Counting Revisions?
- Most efficient way to list all categories and display a post for each of them?
- database columns: post_title vs post_name
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Exporting Data from WordPress into a flat table
- Insert posts in two tables
- Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
- Importing New Posts from Live Site into Local Dev Site
- Manually removing revision post types
- How much of my site can I recover from public_html?
- Reset/Reorder posts ID in the MySQL wp_posts table
- How to store an extra (surrogate) ID when creating a post with wp_insert_post?
- How do I find which articles are missing a featured image in The WordPress database?
- Split WP_POST table based on post types
- Most recent post from another database
- What structure should post_content have in the database?
- Multiples Empty Posts were created and cannot delete them
- How to delete all the content of a wordpress site without deleting the Post and pages?
- Extracting post categories
- How to modify post content?
- After database migration, posts not showing up in dashboard
- Transferring WordPress Database – Serialised data
- Emojis replaced by ‘?’ automatically
- WordPress Local And Live Site
- Can’t update old posts 3.5.2
- Copy post to separate database with “add_action(….)”
- When open add new post or page WordPress add post with ID=0 continuously [closed]
- wp_posts table: safely remove unused columns to save database storage
- Anyone know why wordpress converts some html entities to their numeric equivalents?
- Remove a shortcode from all WordPress posts
- What do these phpMyAdmin errors mean on my WordPress databaes?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- why there are so many posts whoes post_type is revision? will these records waste too much database space?
- Delete all drafts?
- Is it possible to use WP_Query to only pull posts with attachments?
- Get posts and include taxonomy term
- Why my wp_posts data is so huge?
- Add field to user meta table in database when link is clicked
- How safe is it to delete old posts edits to save database space?
- Delete post revisions only for a single post
- Move posts from a non-wordpress site to wordpress
- wp_posts table extremely large
- How to Assign / Move all Deleted post to a category
- Display post number by category
- Saving Post Data in Another Database
- Queries take 120+ seconds on my large WordPress site
- Restore woocommerce orders
- How to select particular month post from table and update the post status using MySQL?
- Update field in database for users
- Import custom database into wp and keep the post id
- why the posts queried from sql is more than those showed on the page?
- Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
- Is there a function to get post info for any publish_status by post ID?
- Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
- How Can I Always Display A Particular Post First Using WP_Query?
- Help on conditional statement to accompany wp_insert_post function please?
- How can I globally italicize list of texts in the UI database or Posts? [closed]
- Is it possible to modify posts table to only read for more recent ones?
- How to optimize posts query in wordpress
- Menu Items disappearing/being empty on save or post edit
- My website is showing today’s date instead of published date since db migration to a new wordpress
- How to setup default value of post_id
- Prevent a post with a specific ID from being created
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Trigger on DB make problem on wordpress?
- Comments are in database, don’t show up in WordPress backend or frontend
- Is there a way to save different data when USER interacts with the same POST?
- How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
- More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
- how i show manual data in a post
- Clean up customize_changeset in DB
- How do I get a certain set of posts from the database?
- Maximum number of posts per page before affecting performance?
- SQL trigger failes with post_content
- Surrogate ID for posts, is there an alternative field in the posts table?
- get backup file from wordpress database in x days
- Expired Post with More Recent Time Stamp?
- I moved my site to another server, wp admin works so does the front page, but posts don’t work
- How to change the publishing date of each posts?
- Can’t seem to replicate permalink structure for localhost development site
- Extra field in wp_post instead of postmeta
- Voting System, database connections?
- When I click edit on a post, all the content disappear. Does anyone know how to fix this?
- Given two custom post types: Automatically add meta fields from one custom post type to another
- Is there a maximum amount of pages for a multi-page post?
- How to make category for word post_content
- What effect can a large wp_post table have on overall site performance?
- How can I merge a several related posts into one post?
- Restore posts, but only posts that exist in my database backup
- Change permalinks in posts via SQL
- Optimize blog that serves hundred of images and videos