Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Yes, <a href="http://msdn.microsoft.com/en-us/library/364x0z75.aspx" rel="nofollow"><code>decimal</code></a> is designed for just that.</p> <p>However, do be aware that the range of the decimal type is smaller than a double. That is double can hold a larger value, but it does so by losing precision. Or, as stated on MSDN:</p> <blockquote> <p>The decimal keyword denotes a 128-bit data type. Compared to floating-point types, the decimal type has a greater precision and a smaller range, which makes it suitable for financial and monetary calculations. The approximate range and precision for the decimal type are shown in the following table.</p> </blockquote> <p>The primary difference between <code>decimal</code> and <code>double</code> is that <a href="http://floating-point-gui.de/" rel="nofollow"><code>decimal</code> is fixed-point and <code>double</code> is floating point</a>. That means that decimal stores an exact value, while <code>double</code> represents a value represented by a fraction, and is less precise. A <code>decimal</code>is 128 bits, so it takes the double space to store. Calculations on <code>decimal</code> is also slower (measure !).</p> <p>If you need even larger precision, then <code>BigInteger</code> can be used from .NET 4. (You will need to handle decimal points yourself). Here you should be aware, that BigInteger is immutable, so any arithmetic operation on it will create a new instance - if numbers are large, this might be crippling for performance.</p> <p>I suggest you look into exactly how precise you need to be. Perhaps your algorithm can work with normalized values, that can be smaller ? If performance is an issue, one of the built in floating point types are likely to be faster.</p>
    singulars
    1. This table or related slice is empty.
    1. POCan C# store more precise data than doubles?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCallum Linington
    1. USdriis
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCan C# store more precise data than doubles?
      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. COInteger, double, float, decimal are all immutable too and arithmetic operations create new instances...so that's a red herring. Decimal and BigInteger are slow because they aren't just simple hardware primitives.
      singulars
      1. PO
      1. USMark Sowul
    2. COWell, all right, it's not totally a red herring because they can grow arbitrarily large in contrast to the other fixed-size numeric types, but if that's the case the value wouldn't fit in other types anyway.
      singulars
      1. PO
      1. USMark Sowul
    3. CO`Decimal` is a floating-point type, even though its dynamic range is less than that of `float`. I find the design curious, given that the type takes 16 bytes, and a type with a 68-bit whole-number part and 60-bit fraction could have done almost everything `Decimal` does more efficiently. Not quite as much range on the high end nor precision on the low end, but capable of guaranteeing that addition and subtraction will either be performed with perfect precision or else fail entirely--a guarantee not provided by `double`.
      singulars
      1. PO
      1. USsupercat
 

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