Dealing with large datasets in MapDisto
04/10/12 23:20 Filed in: MapDisto
If your mapping project contains very large number of markers (or individuals), MapDisto may tell you that the computer is running out of memory. This is due to the way VBA is dealing with available RAM, which varies with the Operating System (Windows, OS X) and the version of Excel (2007, 2010, 2011).
One solution I’ve found is to run MapDisto in 64-bits mode. This means installing Windows 7 pro 64-bits and Excel 2010 64-bits (yes, OS X is 64-bits, too, but VBA in Excel 2011 isn’t).
And this means some code improvement. I’ve got a version that works, so if you’re interested in using it please contact me. I’m not posting it for now as I may go into the code a couple more times in the next future.
Although this solution may not be affordable for any lab, this is the only solution I’ve found so far with the limited time I can dedicate to software development.
One solution I’ve found is to run MapDisto in 64-bits mode. This means installing Windows 7 pro 64-bits and Excel 2010 64-bits (yes, OS X is 64-bits, too, but VBA in Excel 2011 isn’t).
And this means some code improvement. I’ve got a version that works, so if you’re interested in using it please contact me. I’m not posting it for now as I may go into the code a couple more times in the next future.
Although this solution may not be affordable for any lab, this is the only solution I’ve found so far with the limited time I can dedicate to software development.