Topic: To accelerate filling of copies of a class with the data
At nested excel th file on the tab "Initial data" there is data which are received by means of outswapping. The task such that from this data it is necessary to receive the unique list of copies of a class (+SKU++), and then to scatter the data on appropriate copies of a class. Further on each copy there are chain calculations on days. In the given example chain calculations are not resulted and in the code in a class there are properties for results. In general, the code is written, the code works. But is but.
1. It seems to me that I not absolutely correctly wrote the code. Because, if 500 000 lines long reads out, then for filling of each copy of a class it is necessary to be transversed on all lines and if finds takes the data from current line and interposes into appropriate copies. Then long there are chain calculations in each copy though it is other question. Whether it is possible how to optimize data reading at sight, search unique, creation of copies of classes and their filling on the certain logic that worked faster?
2. After all copies of classes, but before chain calculations, that is necessity to save copies a dataful format in what that are created and filled. Then anew not to read out at sight, and to preempt from that file, where the data not simply as the relational table, and as class copies. And after carrying out of chain calculations in this file results of calculations are filled. It is possible as that to make? There is such data format?
Do not pay attention that variables in Russian, it that the code was easy in understanding.