Planned for version 8.3.22
We've provided version 8.3.22 with a new feature, a binary data storage.
With this feature, you can store large binary data (Binary Large Objects, BLOB) in a special storage rather than in the database.
Infobase tasks often require to store and process data entered interactively and to link it with various attachable files: document scans, photos, audio, video, and other. For example, when you create a contract in 1C:Document Management, you need to attach a scan of the hard copy.
When you store large binary data in DBMS, you might face a number of issues, such as:
- Binary data is stored in the used DBMS along with the other information. Operations with this data and with the database are executed concurrently, which might lead to high load on hardware capacity and possible performance loss.
- Large binary data stored in the DBMS increases the database size, which complicates the system operation:
- Database backup and restore issues.
- System scaling issues.
- Extended duration of database update and maintenance (long defragmentation and restructuring).
We've introduced binary data storage to solve all these issues.
Using binary data storage
We've added the Binary data storage management data processor to standard data processors. They are available from the Functions for technician menu. In this data processor, you can enable and set up the new feature.
We've also introduced new Binary data storage use property for Designer starting from 8.3.10 compatibility mode. When you set this property to Use, all the ValueStorage attributes with the size exceeding the size in the settings will be saved to binary data storage. It happens if binary data storages are enabled and the Read only mode is not enabled for the storage.
If you enable binary data storage for a certain infobase, one part of data will be stored in DBMS and the other part will be stored in a special 1C:Enterprise server cluster directory. That is why, it is recommended to back up both the database and the binary data storage.
Binary data storage is available only in the client/server mode.
Developers and end users can easily operate with binary data storages. There is no need to check whether the storage is used or not and to modify the configuration.