06-25-2010 02:36 PM
I'm running ACT 2009 and need to know how I can get a little over 2,000,000 records into the database. Is it possible? I'm running a fast quad core computer with win 7, 4 gig of ram and 71 gig left on a fast hard drive. I also have a terabyte hard drive that could be used if necessary. What do I need to do?
06-25-2010 08:00 PM
Hello Tom. First, be aware that I am not an engineer, just a user. From reading other posts on this board, you are only limited to your HDD capacity. While an external 1TB hard drive may hold the 2 million records, retrieval activity will be impacted because it is external.
It would be best if your primary drive has the capacity.
It shold be fairly simple to estimate the size of the HDD you need. See how much your current db is taking and divide it by the number of records. Then multiply that by 2 million. Needless to say that is only an estimate. It will all depend on the amount of data in each record, of course. Memo fields are the one that are not clearly defined for size. (Would one of the consultants verify my last statement?)
Regardless, it should give you an estimate.
06-26-2010 07:39 PM
Thanks for the response. The terabyte drive is internal so I should have plenty of room. I will probably have to upgrade my ram and may have to go to an SSD due to the speed requirements of such a large database..