Currently, the minimum roundtrip time to access a remote database through an external table or external source in Azure SQL DB is around 100msec. Looking at your queries I worry...