Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First of all, <a href="http://msdn.microsoft.com/en-us/library/system.string.aspx" rel="nofollow"><code>String</code></a> and <a href="http://msdn.microsoft.com/en-us/library/System.Text.StringBuilder%28v=vs.110%29.aspx" rel="nofollow"><code>StringBuilder</code></a> are different classes.</p> <p><code>String</code> class represents <a href="http://en.wikipedia.org/wiki/Immutable_object" rel="nofollow"><em>immutable types</em></a> but <code>StringBuilder</code> class represent mutable types.</p> <p>When you use <a href="http://msdn.microsoft.com/en-us/library/vstudio/k1a63xkz%28v=vs.110%29.aspx" rel="nofollow"><code>+</code></a> to concatanate your strings, it uses <a href="http://msdn.microsoft.com/en-us/library/system.string.concat%28v=vs.110%29.aspx" rel="nofollow"><code>String.Concat</code></a> method. And every time, it returns a new string object.</p> <p><a href="http://msdn.microsoft.com/en-us/library/system.text.stringbuilder.append%28v=vs.110%29.aspx" rel="nofollow"><code>StringBuilder.Append</code></a> method appends a <em>copy</em> of the specified string. It doesn't return a new string, it changes the original one.</p> <p>For efficient part, you should read Jeff's article called <a href="http://www.codinghorror.com/blog/2009/01/the-sad-tragedy-of-micro-optimization-theater.html" rel="nofollow"><code>The Sad Tragedy of Micro-Optimization Theater</code></a></p> <blockquote> <p><strong>It. Just. Doesn't. Matter!</strong></p> <p>We already know none of these operations will be performed in a loop, so we can rule out brutally poor performance characteristics of naive string concatenation. All that's left is micro-optimization, and the minute you begin worrying about tiny little optimizations, you've already gone down the wrong path.</p> <p>Oh, you don't believe me? Sadly, I didn't believe it myself, which is why I got drawn into this in the first place. Here are my results -- for 100,000 iterations, on a dual core 3.5 GHz Core 2 Duo.</p> </blockquote> <pre><code>1: Simple Concatenation 606 ms 2: String.Format 665 ms 3: string.Concat 587 ms 4: String.Replace 979 ms 5: StringBuilder 588 ms </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODifference between using append method of StringBulder class and concatenation "+" operator
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSoner Gönül
    1. USSoner Gönül
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODifference between using append method of StringBulder class and concatenation "+" operator
      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. COI sadly can't upvote that answer enough for linking to Jeff Atwood's excellent article...
      singulars
      1. PO
      1. USelgonzo
 

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