title: Which is more efficient coding?
body: <p>I have a bible project and I need some inputs from experts to determine which is faster and more efficient in displaying results in the page.</p>
  
  <p>My Bible table contains only 3 fields at the moment? id, verse_code, and verse_content.</p>
  
  <p>For me to be able to display appropriate Bible Book and verse in word (ex. Genesis 1:1), I am doing switch-case statement on verse_code that includes 66 cases something like...</p>
  
  <pre><code>select (verse_code)
  {
  case 1: echo "Genesis";
  case 2: echo "Exodus";
  ...
  case 66: echo "Revelation";
  }
  </code></pre>
  
  <p>I can keep it this way or I can add new column <strong>book_name</strong> and input book name of each corresponding verse. This will be equivalent to 31,103 rows.</p>
  
  <p>Performance wise, which is faster between these 2 approach. Shall I keep my case statement of shall I input the book name for 31,103 rows?</p>
  
  <p>Test code is here. 
  <a href="http://sandbox.littlegraffyx.com/bible/test.html" rel="nofollow">http://sandbox.littlegraffyx.com/bible/test.html</a> to use it, try entering Gen x:x where x is chapter and verse and first 3 letters of book. Sample: Gen 1:1 or Exo 2:2</p>
  
  <p>The textbox is located at the bottom left </p>
  
  <p>Thanks</p>