Dear All,
I have developed some algorithms for organizing and analyzing a large dataset of Excel files (2GB). Each algorithm is included in multiple modules, and hence they are very long to display here.
When I try the codes with small datasets (few Excel files, 10 for example), it works with any computer irrespective of the specifications. When I try to work with the whole dataset, however, the process halts in the middle without giving any kinds of errors. This problem disappears if I use a 2X Xeon QC old XP computer!
I have extensively searched the web for better understanding, but haven't reached any conclusions.
Could anyone advise please?
Thanks in advance-
I have developed some algorithms for organizing and analyzing a large dataset of Excel files (2GB). Each algorithm is included in multiple modules, and hence they are very long to display here.
When I try the codes with small datasets (few Excel files, 10 for example), it works with any computer irrespective of the specifications. When I try to work with the whole dataset, however, the process halts in the middle without giving any kinds of errors. This problem disappears if I use a 2X Xeon QC old XP computer!
I have extensively searched the web for better understanding, but haven't reached any conclusions.
Could anyone advise please?
Thanks in advance-