This is one of the few cases i would prefer using custom database tables since you are talking about lots of records (10,000 – 100,000) and since Custom post types use the posts table which will hold many empty fields in the case you describe.
But i guess there is no right or wrong way to do that and it’s a matter if opinion since a good (correctly) configured MySQL database can handle a lot more then a few 100,000’s records without a glitch.
Related Posts:
- Allow member to have access to custom post type only. Permission to only edit their own posts
- add_rewrite_endpoint() not working for custom post type archives
- Pagination with custom post type not working
- WP_Query() show posts that end later than today
- Custom post type URL with post ID that allows archiving and paging
- How do i display the post type title?
- Sorting a query by custom field date
- custom post type archive page url to point to Page permalink
- WordPress Custom Post Type Category Page
- White screen error for a custom theme
- Custom post types – RSS lastBuildDate issue
- Determine which template-{slug}.php is being loaded
- disable /feed/ for custom post type
- Archive page for taxonomy of custom post type
- CPT tax slug conflict with post type slug
- $wpdb returns no results with SELECT query on custom post type, works on default post type
- Display Post Author for Custom Post Type in Edit-Post Screen
- Hide Meta Boxes for Non-Admins
- Permalinks for Taxonomy and Custom Post Type
- Custom Post Type, Saving Multiple Checkboxes
- Hook to override title, image and content
- Populate dropdown from one custom post type inside another custom post type
- No posts found – Custom Post Type show_ui
- Customize my custom taxonomy table in Admin panel
- How do I do this with WordPress? Taxonomies?
- Custom-Posttype & Custom Taxonomy WP_Query
- Display Ad on Specific Categories
- Custom setting to show or hide field
- Redirect 404 page with ID in slug to associated page with same ID in slug
- Only keep the First and Last Revision of a post
- Content vs Template on custom post
- Show post in table front end
- Custom Post Type Permalink empty
- Add custom column to post list table
- Why is my category template ignoring post type?
- the_content filter on some post types only not working
- A form that can save/edit after first input
- Create 2 Post Types, one parent to another in Plugin
- Can slugs from posts and custom post types conflict?
- Integrate Custom Post Type Events into Calendar
- BBPress Search results in WordPress search
- Form action doesn’t work if slug isn’t same as custom post title
- Retrieve custom post types by custom taxonomies with WP_Query
- Pages Become “Archive” Instead of Using Page Template
- How do I add a Custom Post Type that looks and behaves exactly the same as Posts?
- Custom Post Type archive-{post-type}.php not working
- Custom post type single page (single-{CPT-name}) 404 when slug includes hyphens
- Custom URL redirect in WP
- Custom Post type & Taxonomy 404
- How can I include active content in a custom post type?
- Custom Category Walker with Image, Fallback to Most Recent Post in Category Image
- How can I output WPAlchemy repeating fields meta values in my page template?
- Displaying a list of Contacts
- Custom Sidebar in Editor (not Widget) for Custom Post Type in Genesis
- Questions regarding add_meta_box()
- Loop Post Types with Name and Links
- Custom post pagination trouble
- How to Control CSS Class Visiblity From WordPress Admin Panel based on Tax Terms
- Best Way to Query Custom Taxonomies Used on Custom Post Type
- Galleries of images attached to posts
- Retrieve posts by author
- Last post in loop – custom post types
- Question about link two types of data in wordpress
- Adding Category Name in Slug in Custom Post Type
- Add Tags to a Custom Post Type from a FrontEnd Form
- Archive page of CPT’s custom Taxonomy
- How to mass get post editor URLs
- Custom Post Type add_rewrite_rule
- Post type to appear on every page on site
- How to show related posts of category on post within custom posttype
- Saving custom JSON as custom post type
- Get custome post type name
- Custom search for a custom post type in WordPress
- Remove wp directory and slug for custom post type from the URLs
- WPML – Auto Duplicate Post Issue
- Loop carousel slider in wordpress
- How can I add a “fake” parent into the permalink?
- Best way to structure article and issue relationship for CPT
- How to display custom post types AND regular posts separately on a shared taxonomy archive?
- Custom Post Type used for FAQs Accordion
- Custom post types working in functions.php but not in plugin
- Change column of row action (Quick Edit) links in WP_List_Table
- Missing categories for Custom Taxonomy and Custom Posts
- Custom Post Type Slug / Page Slug Conflict – Prevent use of reserved slug on page save?
- How do I add a checkbox option to this custom post type code?
- Comment moderation with disqus comments
- 404 on Pages for Custom Post Type & Query_Posts
- Classic Custom Post Types and WP-PageNavi
- Can I set a CPT title field to a dropdown with preset options if user is of a given type?
- List of filtered Events is breaking paging?
- Show one of the taxonomies always as default
- How can i manually relate pages?
- Pagination for Custom Post Type with Multiple Types
- From form submission values – dynamically update CPT “has_archive” slug and custom taxonomy “rewrite” slug value
- Url rewrite with custom post type and taxonomy
- wordpress category form fields in popup
- How can I show posts with the same tag?
- How Do I Add a Custom Post Type URL to Content?
- What is the best way to relate different custom post types?
- Custom Sort Order for Custom Post Type Taxonomy