Good Afternoon,
wondering if anyone might be able to offer some alternatives.
We have a table that in essence holds a snapshot of various metrics, across several lines by 15 minute period, by day - as you can imagine this is quite large, I believe there's some data missing as we had a little hiccup with the import mechanism (that's now resolved) and I've built the following routine to loop through and help identify if and where the gaps are so that we can reimport the missing data.
I've added commentary to illustrate the current bounds for the arrays but this will grow as other metrics (queues) are added and back filled, aside from increase the time between 'doevent' cycles is there a faster way of achieving the same result? at the moment its taking about an hour, maybe more to complete.
I have tried a loop with a dcount on the source table but there was a 2 second(ish) delay which it was checked which I think would be just as long (if not longer) than this method.
Thank you in advance.
Bookmarks