Speed up for loop
Show older comments
I need to speed up this code, T is a table with 5 columns and approximately 1 million rows. The code is doing what I need but it is pretty slow, it takes 1 hour to do the calculation. Someone can help?
Thanks in advance
rmsA = zeros(height(T),1);
for i=1:height(T)
tf = isbetween(T.VarName1,T.VarName(i)-minutes(2),T.VarName(i)+minutes(2));
xA = T.VarName2(tf);
rmsA(i) = rms((xA-993)/102.04);
end
2 Comments
BALAJI KARTHEEK
on 23 Apr 2020
Use parallel computing and parfor loops are available in matlab exactly to solve these type of problems
darova
on 23 Apr 2020
Can you attach sample data for experiments?
Answers (1)
Sulaymon Eshkabilov
on 23 Apr 2020
1 vote
To process date data format is slow. Thus, you can convert all into a serial date number using datenum() that shall speed up the simulation process.
good luck
2 Comments
Emiliano Ascenzi
on 24 Apr 2020
Med Aymane Ahajjam
on 28 Jul 2021
treat them like you would with normal numbers : .. < .. < ..
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!