Skip to main content
Solved

Performance of Cloud File Storage


Forum|alt.badge.img+9
  • Hero (Employee)
  • 80 replies

Does anybody have experience with the performance of the repository type ‘File Storage’ compared to ‘Database’?

I would expect that it’s a little bit slower to download a file from Cloud File Storage than reading it from the database.

  • But how big is the difference really? (Did anybody measure it? E. g. is it just about 50ms more?)
  • Does the difference depend on the file size? (Means: Is downloading from ‘File Storage’ much slower for big files?)
  • Does is depend on the number of files? (Means: Will ‘File Storage’ get much slower if you have millions of files?)

Any practical experience is highly appreciated.

Best answer by Mathias Dahl

I cannot remember any performance comparisons being done. I would not expect any significant differences. Both the database and Azure Storage lies in the cloud. Perhaps for smaller files if one or the other options has some little overhead, it might be noticable. For larger files the differences should be small.

The number of files should not have any impact at all.

If you have a customer in Cloud deployment it's not very hard to do some example uploads and downloads and see for yourself.

What's the background for the question? We have some really large deployments that uses File Storage.

View original
Did this topic help you find an answer to your question?

4 replies

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2814 replies
  • Answer
  • May 16, 2024

I cannot remember any performance comparisons being done. I would not expect any significant differences. Both the database and Azure Storage lies in the cloud. Perhaps for smaller files if one or the other options has some little overhead, it might be noticable. For larger files the differences should be small.

The number of files should not have any impact at all.

If you have a customer in Cloud deployment it's not very hard to do some example uploads and downloads and see for yourself.

What's the background for the question? We have some really large deployments that uses File Storage.


Mayura Wasantha
Superhero (Employee)
Forum|alt.badge.img+18

@dhanikw  @JagathJ  - Do you have any open insights/feedback on the above questions? Please update.


Forum|alt.badge.img+9
  • Author
  • Hero (Employee)
  • 80 replies
  • May 17, 2024

Hi Mathias,

 

thanks a lot for your response.

Background of my question was that none of my customers uses File Storage until now and therefore I don’t have any experience even if I know the documentation. But now a customer asked for my advice when lifting from Apps10 to IFS Cloud. This customer has millions of files with several TB of data volume. Therefore, for me it was clear that File Storage is the only possibility for such a volume. But customer had the fear that File Storage would be too slow. It’s good that I can tell him now that no significant differences are to be expected.

 

Best regards, Heinz


chanaka-shanil
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 165 replies
  • May 18, 2024

We have done some benchmarking related to FS for Remote using a SMB share. The results were that when the number of files increased, we did NOT see a significant drop of performance. This may differ based on your system configuration (we used high speed disk).

If you are using FS in an IFS Cloud Managed Environment, then again you should not see a significant drop as we are using high performance storage accounts for the purpose. 

Out of interest, I ran a quick test on a managed environment using a 12MB file upload to both DB and FS. The DB was indeed slightly faster on average, 816 ms for DB vs 935.39 ms for FS.  

However, we do need to factor in that all files stored in the FS will be scanned (when stored and when retrieved) for viruses using the virus scanner. This is optimized so that we don’t scan unnecessarily. However, the checks done will add to the download time.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings