Azure storage table slow with scheduled refresh

All forum topics
Previous Topic
Next Topic

Hi,

Recently I have switched storage from Microsoft SQL server to Microsoft Storage table. Unfortunately this change resulted in significantly slower refresh time of the data. Especially the scheduled refresh in the server, this takes about 20 minutes for 300k rows.

Also, when I refresh manually in the service, it only takes a couple of minutes..

Is there a way to reduce the refresh time? And what would be the best alternative for MS storage table (taking costs into account)?

Thanks!