title: Table Layout for perfomance (Multiple Query vs One single big query)
body: <p>I have a straightforward question. </p>
  
  <p>I am doing a web application that uses MySQL, and I am currently designing it. I just have a small question about performance. </p>
  
  <p>I would like to know what is more efficient: </p>
  
  <p>Scenario #1:</p>
  
  <pre><code>Table: Restaurant
      -Name
      -City
      -Province
      -Country
      -Continent
  
  sql =~ select * from restaurant where id = something.
  </code></pre>
  
  <p><em>or</em></p>
  
  <p>Scenario #2:</p>
  
  <pre><code>Table: Restaurant   
      -Name
      -City
  Table: City
      -Name
      -Province
  Table: Province
      -Name
      -Country
  Table: Country
      -Name
      -Continent
  Table: Continent
     -Name
  
  sql =~ [insert multiple sql queries that will output the name and the city,
          with the corresponding province, country, and continent]
  </code></pre>
  
  <p>Logically, I think Scenario #1 is better (less query), but some people swore to me otherwise.</p>