Skip to main content

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.

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.

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

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

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


Terms & ConditionsCookie settings