Custom Post Type for huge number of records. (3 posts)

  1. Joms
    Posted 5 years ago #


    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.

  2. The speed would be more dependent on your server setup than WP. I mean, WordPress.com uses WP and has millions of posts :)

  3. Joms
    Posted 5 years ago #

    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.

    Thanks again.

Topic Closed

This topic has been closed to new replies.

About this Topic