Hi All,
I have a 20M dataset. The dataset have customer Latitude, Longitude info and corresponding store Latitude Longitude info. I want to calculate Drive time and drive distance from Customer to Store.
But I saw that the run time is really huge.
So I checked with 100 sample records.
What I found is:
For small distances between two points (Say less than 10 miles), Alteryx Spatial is not taking much time to calculate Drivetime and Drive distance.
But for large distances, it is taking so much time.
My intuition is that for bigger distance it usually take much time. Is it true?
Can anyone please suggest me what is the convenient way to complete this?
Solved! Go to Solution.
It's true that longer distances take longer to compute, and there isn't much getting around that for drive times. Make sure the dataset is installed on a local drive (same computer that's running Alteryx) and not on a network drive for best performance.
Thanks Charlie.
I have the same issue ... very large datasets making driving distance impossible to use. I submitted a suggestion this morning asking for "estimated driving distance" Which would be helpful for compliance calculations.
That many records will make it more difficult, but certainly not impossible to use. There's no limitation by the product, only in how computer resources are used to process this request. I suggest breaking up the record calculation using a batch macro to better manage computer resources, or across multiple computers simultaneously.
I agree there is no record limitation but ....