Calculation speed using db or application
Dear all,
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
Thanks
Brian
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
Thanks
Brian
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hmmm both of you confirmed my fears ;-)
saving the network traffic will be worthy the dread of writing stored procedures
thanks for the input and have a great weekend!
saving the network traffic will be worthy the dread of writing stored procedures
thanks for the input and have a great weekend!
ASKER
screwed the acceptance, should've been just the other way around sorry
no worries .. I think most are here just to help:) if I traded in all my points .. I think I could get 30 tickets for the skeeball store (and we all know what 30 tickets gets you)
ASKER
:)
"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?"
inserting the data back to the db .. it takes a huge amount of calculation to overcome the network overhead associated with a large read combined with n writes over the network.