[AccessD] A2K: Time diff calcs

Hi Darren and Stuart

Except for very excessive processing, processing time will be
negligible compared to the time for reading and, indeed, writing the
data.
However, should heavy processing be needed, process the values in Long
variables even if they are stored as Integer.

For short intervals, four minutes or less, the seconds could even be
stored as Byte.

/gustav


> On 15 Sep 2004 at 21:06, Darren DICK wrote:

>> Hi Arthur
>> Many thanks for the tip and I agree. Store the seconds format when needed.
>> In the relevant table should the data type be Integer?

> if you need more than 32767 seconds (a bit over 9 hours) you will need to 
> use a long.
> If you  don't need that much, it is debatable.  Integers take half the 
> storage of longs, but take a bit longer to process if you are manipulating 
> them. Depends on whether you want to save on storage or optimise processing 
> time. 

> However don't save them as singles or doubles.

> -- 
> Stuart