Forum Discussion

Michieldo's avatar
Michieldo
Icon for Helper III rankHelper III
5 years ago

Azure storage table slow with scheduled refresh

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!

No RepliesBe the first to reply