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!