Custom Post Type for huge number of records.

  • Joms

    (@jomsky)


    12 years, 10 months ago

    Hi,

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 10 months ago

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

    Thread Starter Joms

    (@jomsky)

    12 years, 10 months 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom Post Type for huge number of records.’ is closed to new replies.