Fetching data from Statistics Canada is painfully slow
Posted: Fri Apr 25, 2025 2:25 pm
First: thanks to the EViews team for adding the Statistics Canada data connectivity feature. It's pretty handy to have!
But, at the moment, its usefulness is severely limited by the fact that it takes a very long time for me to fetch data from it. I will share some details below about that.
In this example, I fetched 148 series and it took 26 minutes!
What's interesting is that once the data is fetched, fetching it again shortly after time takes very little time (6.4 seconds).
Is this normal? Is there anything that could be done?
Thanks!
But, at the moment, its usefulness is severely limited by the fact that it takes a very long time for me to fetch data from it. I will share some details below about that.
Code: Select all
mode quiet
%data = "INSERT SERIES HERE (SUPPRESSED)"
tic
table clock
!n = 1
For %1 {%data}
fetch(db=statcan) {%1}
clock(!n,1) = !n
clock(!n,2) = @toc
!n = !n+1
Next
delete df*
'Fetch a second time:
tic
table clock2
!n = 1
For %1 {%data}
fetch(db=statcan) {%1}
clock2(!n,1) = !n
clock2(!n,2) = @toc
!n = !n+1
NextIn this example, I fetched 148 series and it took 26 minutes!
What's interesting is that once the data is fetched, fetching it again shortly after time takes very little time (6.4 seconds).
Is this normal? Is there anything that could be done?
Thanks!