Re: Advantage of using byte over Long Integer?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 07:09:25 -0600

J P Hill wrote:
> I'm using an Access DB to do a series of calculations. Most of the
> data are stored as doubles to maximise accuracy. However, the Year
> and Month (which are only used for referencing) are stored as Long
> Integers. Am I likely to achieve any increase in performance by
> changing month (i.e. 1 - 12) to Byte and year to Integer?

No.

There is validity to the standard of using the DataType that is large enough for
the job, but no larger, but unless you get into the huge number crunching tasks
normally assigned to "Big Blue" you are not likely to see any difference.

If you set up a test loop and did enough iterations a difference might show up,
but as far as something that your users would notice I would say there's almost
no chance of that. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Advantage of using byte over Long Integer?
    ... I'm using an Access DB to do a series of calculations. ... data are stored as doubles to maximise accuracy. ... and Month (which are only used for referencing) are stored as Long ...
    (microsoft.public.access.tablesdbdesign)
  • Re: C sucks at math? (help)
    ... I said I wouldn't try doubles in the real project, ... do similar calculations in a much bigger project and the problem I'm ... the floating point hardware or emulation does. ...
    (comp.lang.c)
  • Re: Java rounding with big Decimal.
    ... That is, more or less, what I meant by "inherently inaccurate". ... less error in calculations involving them than you might with ... I still say BigDecimals are better than doubles, ...
    (comp.lang.java.programmer)
  • Re: double discrepancy between PDA and PC
    ... whatever you use from Math class uses doubles and that might ... calculations, ... the card reader takes electrical measurements off the pins with respect ... depending on the sensor and those are the values I use to do my ...
    (microsoft.public.dotnet.framework)
  • Re: Variable type Money/Currency
    ... By default, doubles cannot be ... > Do I need to take all my calculations and multiply them by 100? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)