If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advantage of using byte over Long Integer?
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
Change Needed - VB Code in excel | Eskimo | General Discussion | 2 | August 27th, 2004 11:40 PM |
Help Needed for Groups Please | Paul Black | General Discussion | 15 | June 21st, 2004 02:54 AM |
Long Integer Limitations | Gary | Worksheet Functions | 1 | September 25th, 2003 10:22 AM |