Whilst at work (in Brighton) on a 50meg leased line
Huge performance difference in API query time (I think) between Azure in Western Europe and my local line. I believe Spotify’s servers are in London so this would make sense to be slightly faster, however such a big difference doesn’t.
Azure Different Plans
Free website – no (as 185MB data limit)
Shared website – yes.. this is what this is on..costing approx 5UKP per month + 5UKP database?
B1 Small Instance – moved to that. 1 Core. 1.75GB RAM. 20UKP per month + 5UKP database?
Website in West Europe
B Basic - DB is West Europe (max size 2GB)
Spun up a
S1 Small Instance in Northern Europe
B Basic DB in Northern Europe
No massive difference coming from Northern Europe
Spotify Web API Speed Test Page
A page testing the speed of API calls to Spotify
229 : https://api.spotify.com/v1/artists/3hv9jJF3adDNsBSIQDqcjp
461 : https://api.spotify.com/v1/artists/3hv9jJF3adDNsBSIQDqcjp/top-tracks?country=GB
615 : https://api.spotify.com/v1/albums/?ids=3vLaOYCNCzngDf8QdBg2V1,3vLaOYCNCzngDf8QdBg2V1,3vLaOYCNCzngDf8QdBg2V1,3vLaOYCNCzngDf8QdBg2V1,3vLaOYCNCzngDf8QdBg2V1
987 : https://api.spotify.com/v1/albums/?ids=3vLaOYCNCzngDf8QdBg2V1,1cvcW2kVGrN9tdyoaVjmf0,0m8wvW3WNm9D7J0KUlbf3h,1nojrwBYMmq5jY1gJYtywa,0lrBKnE4qQnr8VM56J3gow,4ttFaYVApnyblaGHNwGAf7,62Qu5QoNx3De0p5qQT0u7o,69UMMsDqpBwy7Dr2oZn2Ra,311yDc6Ow5WF8puYAAte1B,05IBZIkN7fdbiVCgGCJCWX,6Z9OaWRC8Bsb64OyhiZ49L,6GMHua20KrXo7MlfwbTWk1,40pk5HrcQ3TDP0KBP3KhfQ,6KZwPiN4oDTcvgtbHGr1A1,2zlXL0UVwQrH9FRFSvNOBg,5hNZOA0YJBq0bGYnWGSo5x,0QluVU5ReXs7oI1ZyS101F,6pJf6YRFeyj615gGq6yDnZ,777UeiexLMf1mFR42nSoR2,2qkxQSusZ6JXAzpnptVUo1
987 : https://api.spotify.com/v1/artists/3hv9jJF3adDNsBSIQDqcjp/albums?country=GB&limit=50
391 : https://api.spotify.com/v1/artists/3hv9jJF3adDNsBSIQDqcjp/related-artists
194 : http://developer.echonest.com/api/v4/artist/biographies?api_key=SECRET&id=spotify:artist:3hv9jJF3adDNsBSIQDqcjp
Work vs Azure
Test to see if it’s actually Spotify limiting me
pass the token?
Seems to make no difference passing a token
In fact, mostly faster without the token
I guess the next thing to do is try it somewhere else. Amazon EC2?
EC2 is fast!
Azure VM - Slow
A1 Azure VM of it being painfully slow. 1.75GB RAM, 1 Core
http://weblog.west-wind.com/posts/2015/Feb/01/Azure-VM-Blues-Fighting-a-losing-Performance-Battle – seems I’m not along.
He went to a high perf cheaper SSD alternative https://www.vultr.com/pricing/
SQL stuff http://www.brentozar.com/archive/2014/09/azure-really-60-faster/
D1 for SSD – creating http://davemateer3.cloudapp.net.. 3.5GB RAM, 50GB SSD, 1core.. £78 per month?
Much faster (even on the micro instance).
Decided to register a domain name – using fasthosts.co.uk.. www.davestopmusic.com