WordPress.org

1. jomsky
   Member
   Posted 1 year 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.

2. Ipstenu (Mika E.)
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #
   

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

3. jomsky
   Member
   Posted 1 year 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.