Answers.Body: <p>Since the data will be imported programmatically, my vote would be to write a plugin that manages these products as a custom thing. There will definitely be a performance benefit to giving your products their own DB table that’s perfectly suited for them, and it doesn’t sound like you’ll be missing any of the features you’d get by having these be actual entries.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-09-28T13:05:05.993Z
Answers.LastActivityDate: 2014-09-28T13:05:05.993Z
Answers.UserDisplayName: Brandon Kelly
Body: <p>i'm just getting my feet wet with craft and would appreciate some pointers.</p>
  
  <p>Basically, what i would like to do is show and compare products. Each product will have a description, price, review, and many other characteristics (>50 in total). Items must be searchable by any single or combination of these. Data will be imported through a script (ie not manually).
  Apart from that there will be articles etc (with maybe 3-6 fields) on the site.</p>
  
  <p>Looking at the craft content table, it looks like an extra column is created for each field. When there are different types of entries, often many/most columns will be null.</p>
  
  <p>My question is: should i be concerned about:
  a) the db structure of craft entries (alternative could be to create separate table for products), especially performance wise</p>
  
  <p>b) searchability of product entries. Would it be easy to search entries by combination of fields?</p>
  
  <p>Not looking for a complete solution, just some pointers i can take along when deciding which way to go :)</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2014-09-15T20:37:13.637Z
Comments.Text: How many products are we talking? Hundreds? Millions?
Comments.UserDisplayName: Brad Bell
Tags: <field><custom-fieldtype><entries-field><custom-field><table-field>
Title: Entry with many fields vs plugin/custom data structure
ThreadText: # Entry with many fields vs plugin/custom data structure
  
  (Asked by: username_0 on 2014-09-11)
  
  i'm just getting my feet wet with craft and would appreciate some pointers.
  
  Basically, what i would like to do is show and compare products. Each product will have a description, price, review, and many other characteristics (>50 in total). Items must be searchable by any single or combination of these. Data will be imported through a script (ie not manually).
  Apart from that there will be articles etc (with maybe 3-6 fields) on the site.
  
  Looking at the craft content table, it looks like an extra column is created for each field. When there are different types of entries, often many/most columns will be null.
  
  My question is: should i be concerned about:
  a) the db structure of craft entries (alternative could be to create separate table for products), especially performance wise
  
  b) searchability of product entries. Would it be easy to search entries by combination of fields?
  
  Not looking for a complete solution, just some pointers i can take along when deciding which way to go :)
  
  **Tags:** field, custom-fieldtype, entries-field, custom-field, table-field
  
  > **Comments:**
  > **username_1**: How many products are we talking? Hundreds? Millions?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2014-09-28. Score: 1
  
  Since the data will be imported programmatically, my vote would be to write a plugin that manages these products as a custom thing. There will definitely be a performance benefit to giving your products their own DB table that’s perfectly suited for them, and it doesn’t sound like you’ll be missing any of the features you’d get by having these be actual entries.
  
  
  ---
  
  