Partitions add-on

Description

Partitioning addon let you split database into several files either horizontally (on rows basis) or vertically (on tables basis). Read in-depth guides below for more details

Restrictions

Data inside horizontal partitions can not be saved/loaded properly with SaveLoad addon

Horizontal vs vertical partitioning

Horizontal Vertical
Main purpose Split database data into several files and load/unload data at runtime manually to reduce memory usage Split database data into several files in multi-user environment to reduce the complexity or even get rid of necessity of data merging.
Based on rows tables
Loaded automatically No Yes
Default file name format bansheegz_database_p_{ID}.bytes" bansheegz_database_v_{ID}.bytes"
Read in-depth guide READ READ

Custom partition file names

Starting with BGDatabase 1.8.11 you can override partition file names. Add assetFilePath field with string type to your partition table (DbPartition or DbPartitionVertical ) and enter custom file name for each partition. Use only letters, numbers or underscore characters. Final file names will be bansheegz_database_{YourName}.

Parameters

Parameter name Description
Disable temporarily Temporarily disable addon without deleting corresponding configuration data (e.g. DbPartition table etc.). With addon temporarily disabled, the whole data is saved into main database file and partitioned files are ignored. You can temporarily disable horizontal and vertical partitioning separately or disable all at once