Performance based on storing file on TN Database or FIle systems

, ,
1

Performance wise which is better to store Lagre file “Database or File systems” ???

2

It really depends. Here are some questions that may help us find a resolution:

What sort of data are you storing?
How often is the data changing?
Is the data in large chunks or small pieces?
Is the database local to the Integration Server?
Is the file server local to the Integration Server?

3

Green,
What sort of data are you storing?

  • Large Flat file Data.
    How often is the data changing?
  • Once a day.
    Is the data in large chunks or small pieces?
  • Large Junks.
    Is the database local to the Integration Server?
    *No
    Is the file server local to the Integration Server?
    *Yes
    Thanks