title: Is it better to create new fields in post table in Wordpress or create new table
body: <p>I'm quite new to using Wordpress and have problem to figure out what solution to choose.</p>
  
  <p>I have to store over 200.000 entries (books, cds,...) in the posts table of Wordpress. Each of those entries have about 20 different fields to populate.</p>
  
  <p>Therefore, I think I'll have to add new fields to the posts table so store the data.</p>
  
  <p>I'm using the ACF custom fields plugin to do so, but I can see that the custom fields are not stored in the same table as the post table. It's being stored in wp_options table for the categories and in postmeta table for the posts and for each of the fields to populate it will create 2 lines in these tables.</p>
  
  <p>So if I save 20 fields X 2 lines X 200.000 entries in this wp_postmeta table, it will make 8.000.000 lines to go through (maybe not that good for performances).</p>
  
  <p>What would be the best way to achieve this task using Wordpress ?</p>
  
  <ul>
  <li><p>Create a new table ? (I'll not take benefit of the regular post features and cache possibilities)</p></li>
  <li><p>Add new fields to the post table ? (will it be compatible with upgrade of WP ?)</p></li>
  <li><p>Use postmeta/option tables ? (what about performances in this case ?) and go ahead with this solution ?</p></li>
  </ul>
  
  <p>Many thanks by advance for your help</p>