Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>Or any performance wise difference between two??</p> </blockquote> <p>Forget about the performance difference on this level- there may be a microscopic one, but you'll feel it only when doing hundreds of thousands of operations, if at all. <code>switch</code> is a construct for better code readability and maintainability: </p> <pre><code>switch ($value) { case 1: .... break; case 2: .... break; case 3: .... break; case 4: .... break; case 5: .... break; default: .... break; } </code></pre> <p>is mostly much more clean and readable than</p> <pre><code>if ($value == 1) { .... } elseif ($value == 2) { .... } elseif ($value == 3) { .... } elseif ($value == 4) { .... } elseif ($value == 5) { .... } else { .... } </code></pre> <p><strong>Edit:</strong> Inspired by Kuchen's comment, for completeness' sake some <a href="http://www.phpbench.com/" rel="noreferrer">benchmarks</a> (results will vary, it's a live one). Keep in mind that these are tests that run <strong>1,000 times</strong>. The difference for a couple of <code>if</code>'s is <strong>totally negligeable</strong>.</p> <ul> <li>if and elseif (using ==) <strong>174 µs</strong> </li> <li>if, elseif and else (using ==) <strong>223 µs</strong></li> <li>if, elseif and else (using ===) <strong>130 µs</strong></li> <li>switch / case <strong>183 µs</strong></li> <li>switch / case / default <strong>215 µs</strong></li> </ul> <blockquote> <p><strong>Conclusion (from phpbench.com)</strong>:</p> <p>Using a switch/case or if/elseif is almost the same. Note that the test is unsing === (is exactly equal to) and is slightly faster then using == (is equal to).</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POWhat is the difference between Switch and IF?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPekka 웃
    1. USPekka 웃
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is the difference between Switch and IF?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COespecially when there are more than 3 options.. +1
      singulars
      1. PO
      1. USSergey Eremin
    2. COcompletely agree - far too much emphasis on micro-optimisations that always seem to sacrifice readability. Personally, for anything beyond a single if/else i always use switch statements
      singulars
      1. PO
      1. USrobjmills
    3. COfor the sake of completeness, if-else is a bit faster than switch. But again, at this level (especially with PHP) readability > performance.
      singulars
      1. PO
      1. USKuchen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload