I have 16 years of data and a 65 meg datafile. Was wondering if I set my system clock to 2005 whether I could then archive everything before 12/31/04 and keep everything since in my active registers?
This, if possible, would certainly speed up the opening of the file.
Gary
----------------------------------------------- Gary .
Why not save a copy of your 65MB file to whatever medium you choose, delete all transactions prior to 2005, and use the resultant file as your "current" file?
If I did it that way I would not have restore capabilities if I needed to put it back together.
----------------------------------------------- Gary .
In a world of gigabytes, terabytes and petabytes, 65 meg just doesn't seem very big. Is it causing you a problem?
I doubt that you could put it back together in any case. Even if you could, I doubt that it would be easy or neat. Setting the system clock back 5 years does not sound like a good idea. Most software is not expecting to find multiple years of future transactions.
Out of curiosity, I did some timing on opening a 300MB file with 30 years of data versus a 15MB file with 8 years of data
Time to open file after a cold boot:
300MB = 11.8 sec 15MB = 3.4 secTime to reopen file:
300MB = 8.7 sec 15MB = 2.8 secBeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.