We are developing one anaellistic modding modeling tool in .Net.
The main goal of this tool is to launch the model for 5 years and make predictions for the future of In, Out and Stock for various products.
Main Code Workflow 1. Retrieve data from a database. 2. For each date, Process Data (Run Production and Stock Model) 3. After all the dates have passed, update all the data together in the database.
Thus, first of all, there are only two database calls, and first we take all the data in the data sets, and then process them in Ram and do not make database calls.
The problem we encountered was that it took almost one hour for 1 year to launch the model. Our test is to run the model for 5 years in 5 minutes.
We have been working on this problem for almost a month now. Right now, we were able to reach the current model in 1 year in 10 minutes. Below we found out what we found. - When extracting data from a data set, if the tables process all the data for five years, it was difficult to do this, so we separated the data sets in monthly cycles, and now we run the model for a month. This gave us maximum speed improvement. - I tried to reduce the number of cycles inside the model, which works daily. This has not given us much improvement.
You can download one rar file from the following link.
http://dl.dropbox.com/u/4546390/iPlanner.rar
It contains three files.
iPlanner Tables.xls: .
iPlanner Logic.xls: , . , - , , .
Common.cs: " ", . .
excel excel, 2 5 . .Net , .
, .
, .
Advance