> For the complete documentation index, see [llms.txt](https://presetmagician.gitbook.io/help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://presetmagician.gitbook.io/help/manual/reference/global-settings/database-settings.md).

# Database Settings

## Compress Preset Data

{% hint style="warning" %}
This option has been removed in PresetMagician 0.5.9 or later, as compression will now always be used.
{% endhint %}

This setting controls if the preset data should be [stored compressed](/help/manual/reference/global-settings/database-settings.md#compress-preset-data) in the database. 

{% hint style="info" %}
If you change this setting, existing preset data in the database will not be automatically compressed or decompressed - the change is only applied to presets which have new or updated preset data.

To manually compress or decompress existing presets, use the [Compress/Decompress Database commands](broken://pages/-LXlu2rN-CwtuarSb7zN)
{% endhint %}

## Database Statistics

{% hint style="warning" %}
This option was removed in PresetMagician 0.5.9, as it now creates the statistics automatically.
{% endhint %}

This shows statistics about the database. Click the "Collect Database Statistics" button to create the statistics.

## Open Database Location

This opens the database location in your Windows Explorer, so you [can make a backup](/help/manual/concepts/presetmagician-database.md#creating-backups)