Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I just did a quick test and the compiler optimizes the code. This basic example Main method.</p> <pre><code>public static void OptionalParamMethod(bool input, string input2 = null) { } public static void Main(string[] args) { OptionalParamMethod(true); OptionalParamMethod(false, "hello"); } </code></pre> <p>Compiles to this so the optional params are filled in by the compiler.</p> <pre><code>public static void Main(string[] args) { OptionalParamMethod(true, null); OptionalParamMethod(false, "hello"); } </code></pre> <p>As for performance you could argue optional parameters have a slight advantage as there is only a single method call rather than chained method calls like you would normally have for an overloaded method. The code below is compiled output to show what I am talking about. The <a href="https://gist.github.com/iwantedue/7150746" rel="nofollow">difference</a> is quite academic though and I doubt you would ever notice in practice.</p> <pre><code>public static void Main(string[] args) { OptionalParamMethod(true, null); OptionalParamMethod(false, "hello"); OverloadParamMethod(true); OverloadParamMethod(false, "hello"); } public static void OptionalParamMethod(bool input, [Optional, DefaultParameterValue(null)] string input2) { Console.WriteLine("OptionalParamMethod"); } public static void OverloadParamMethod(bool input) { OverloadParamMethod(input, null); } public static void OverloadParamMethod(bool input, string input2) { Console.WriteLine("OverloadParamMethod"); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPerformance differences between overloading or optional parameters?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDavid Ewen
    1. USDavid Ewen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPerformance differences between overloading or optional parameters?
      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. VTAcceptedByOriginator
    1. COCan you tell me how do you view the optimized code ? And this looks like a performance drop to me. Is it ?
      singulars
      1. PO
      1. USBitterblue
    2. CO[Reflector](http://www.red-gate.com/products/dotnet-development/reflector/) lets you view the compiled code. There is no performance drop it compiles out to be the same as any normal method call. PS this was a Debug build if it was a Release build then the compiler would actually have removed the method calls entirely as the method is a NOP.
      singulars
      1. PO
      1. USDavid Ewen
    3. COBut when you call an overloaded method with 1 parameter, 1 object is sent. When you call an optional parameter method with 2 parameters and optimized code sends all parameters (with defaults) more stack space is used and it takes more time to copy values and references.
      singulars
      1. PO
      1. USBitterblue
 

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