Have you tried using the data blend by joining the "col1" as key?
Yes, I did. My dashboard runs for 2 min which is not acceptable (displaying one customer info only, around 10k to 20 k rows) . Our main goal is not to use live data connection.
We have 4000 users so using extracts might be better solution.