Configuring database compression

It is possible to configure compression for the databases that you use with your Guidewire applications. Compression reduces the size of the database.

• The advantage of compression is reduced cost for storage and backups. Compression can also increase performance by effectively making the database buffer caches larger.
• The disadvantage of compression is that the database requires more CPU time to compress and decompress data. However, queries that require either a table scan or a full index scan require fewer physical and logical reads because more rows fit on a single data page.

Consult with Guidewire Support about whether database compression can improve the overall performance of your PolicyCenter implementation.