How to do a loop over a datatable faster in c#

  • Thread starter Thread starter azolfaghari
  • Start date Start date
A

azolfaghari

Guest
Hi List,

I have a datatable, dt which has 100,000 rows. I need to do some calculations over each row in dt. The calculation is very complicated and therefore I can't do it over SQL server. Now the problem is no matter if I use FOR, or FOReach(DataRow r in dt.Rows), the process is very slow. I am just wondering if there is a way to do this faster in c#. I am not sure if any one is familiar with SApply, LApply in R. They are super fast comparing to FOR loop. I think that these functions have been written in c as well. I appreciate any idea.

thanks

Arvin

Continue reading...
 

Similar threads

G
C# - Error while adding Data Header column in data table
Replies
0
Views
140
Gani tpt
G
G
C# - Error screenshot while adding Data Header column in data table
Replies
0
Views
149
Gani tpt
G
G
LINQ C# - How do we get specific column (startswith) of a row in a datatable using LINQ C#
Replies
0
Views
116
Gani tpt
G
L
Datatable add value to a specific Row.Column index.
Replies
0
Views
76
labjac
L
F
The enclosed code gives me the error "ArmyOptions expects a parameter @modelname which is not defined" Any suggestions as to what is wrong?
Replies
0
Views
111
furface44
F
Back
Top