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.
Thanks for your reply. I completely agree, but my concern is about the searching of multiple custom fields since it will require a lot of JOINS or sub queries in the SQL query. I’m not sure WordPress.com has that.
But I’m gonna try it first to see if its speed is reasonable, otherwise I might give Pods CMS Framework a try.
Viewing 2 replies - 1 through 2 (of 2 total)
The topic ‘Custom Post Type for huge number of records.’ is closed to new replies.