I have large set of short time series data (average length of short time series = 20). The total size of the data is around 6 GB. Current system working in following way: 1) Load 6 GB data into RAM. 2) Process the data. 3) Put the forecast value corresponding to each time series in excel.
The problem is every time i run the above system it is taking nearly 1 hour in my 8 GB RAM PC. Please suggest a better way to reduce my time.