I'm using Azure file storage and there was a huge number of files uploaded. A single file will be 250kb in size and there will be 7000 files in a directory. So when the user request I need to get the data from 100 files in a single call. At first, I was accessing the files using native file IO methods after mounting the fileshare in the Azure VM. But it was slow due to file IO. Then I changed the native file IO to Azure Rest API and it was slightly fast.
So does this Azure file storage suits for my requirement or do I need to consider no-sql storages?
What was the exact use cases for file storage?