Which efficiency object to use?

Caro

New member
Joined
May 29, 2016
Messages
2
Programming Experience
Beginner
Hello,
I have a table that store data about differents sites for every second everytime during the whole year .
the columns in the database look likes:
DateTime ,Site1,Site2,Site3,Site4,Site5,Site6,Site7,Site8,Site9
The data looks like:
4/10/2013 2:22:00 PM , 400,500, 235,453,789,123,0,123,5
4/10/2013 2:23:00 PM , 800,500, 235,75,789,123,456,123,75
4/10/2013 2:24:00 PM , 400,500, 235,5,748,0,456,0,453
4/10/2013 2:25:00 PM , 300,500, 27,453,3,123,456,123,0
4/10/2013 2:26:00 PM , 400,500, 67,789,8,456,123,5
4/10/2013 2:27:00 PM , 800,500, 57,453,8,0,456,57,785
4/10/2013 2:28:00 PM , 300,500, 58,453,78,123,7,153,87
4/10/2013 2:29:00 PM , 400,500, 52,453,789,45,456,123,0
4/10/2013 2:30:00 PM , 25,500, 235,453,78,123,456,123,5
4/10/2013 2:31:00 PM , 57,500, 57,453,789,0,78,0,453
4/10/2013 2:32:00 PM , 85,500, 235,453,22,8,456,123,58
4/10/2013 2:33:00 PM , 285,500, 57,453,78,123,78,123,5
....
I need to go over each row in the database and to make some calcutions for each sites and store this calcutions for the next 3 minutes (3 next rows in the database).
Each iteration in the database need to use the calculations that was calculated in the 3 previous iteration.
What is the best way to do this?Which object to use ,so that it will be efficacy?

For example for the data:
4/10/2013 2:29:00 PM , 400,500, 52,453,789,45,456,123,0
I will need the new calcutions that was calcuted before and stored:
4/10/2013 2:26:00 PM , 10,14, 8,58,5,24,78,8
4/10/2013 2:27:00 PM , 58,7, 57,87,8,0,5,57,5
4/10/2013 2:28:00 PM , 5,8, 3,5,78,2,7,7,3

And for the data :
4/10/2013 2:30:00 PM , 25,500, 235,453,78,123,456,123,5
I will need the new calcutions that was calcuted before and stored:

4/10/2013 2:27:00 PM , 58,7, 57,87,8,0,5,57,5
4/10/2013 2:28:00 PM , 5,8, 3,5,78,2,7,7,3
4/10/2013 2:29:00 PM , 7,2, 7,7,23,45,45,73,33

Thanks for you help,
 
Back
Top Bottom