Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleDatabase Filestream

Filestream is a required feature that must be enabled on the Database Instance that CostOS will use.

Filestream, as a feature, allows binary data to be saved to the filesystem instead of the database. This provides a performance enhancement, when used for large ammounts of data. Furthermore, Filestream protects data integrity because the file operations are performed as part of a transaction.

Filestream Data are still saved in tables, like traditional BLOB data types.

Read More

Normally, CostOS Server Installer will enable and configure this feature automatically. See more at Install and configure CostOS Application Database (Microsoft SQL Server) 

 

 

BOQ Items*3000 Items10000 Items50000 Items100000 Items
Size of SQL Server Data file32 MB92 MB436 MB858 MB
Size of SQL Server Log file16 MB42 MB290 MB290 MB
                                                             * Each BOQ item contains 1 assign item as resource.