A bit lazy to find this out by testing so here it goes
-> i have a sql db of 12000 items
-> each has 6 numeric properties
-> for period ranges up to 50000 records per item
now i need to calculate several statistics on the properties over the complete range per item
can do this on the sql db using stored procedures but was wondering if bringing over the data to .NET and do the calculations in there
and upload the completed dataset per item to the db would be faster maybe using multiple threads?
would appreciate some good arguments using this or that way