I am now currently working on a website that holds half a million records. I could tell that using custom post type for this will be very slow knowing WP posts' database structure. Filtering records would certainly query multiple tables for each record (tax_query and meta_query).
Now it's easy to think that I could just create my own tables, but each record is required to have the good stuff of a regular WordPress post like comments, paging, and pretty permalinks.
What is the best way to handle this?
Any suggestions would be greatly appreciated. Thanks.