Optimizing databases for better performance on the enterprise server

Follow

If databases have become "bloated" over the years, optimization may become necessary. This is especially the case for databases that have been upgraded from very old versions over many years.

1.1) XML export

The best way to completely clean up your databases is to export them to the XML format and then re-import them:

  • Stop the server service
  • Copy your databases to a local, temporary directory.
  • Load the old databases separately in version 15 in the client DIRECTLY
  • Export the database to the XML format (Extras -> Export Wizard)
  • Create a new, empty database in .pswe format (DB Manager -> New Database).
  • Import the XML file into the database (Extras -> Import Wizard)
  • Make sure that your databases have the same file name and master password!

WARNING: The following data will be lost during this process:

  • User-defined symbols. You can update these via "Properties" in the General tab by using the "Update Symbols" button.
  • All attachments. Therefore, you should convert them manually first as described below.


1.2) Other than the XML export


If you do not want to perform the XML export (for example, because you use too many attachments and do not want to convert them manually to document types), proceed as follows:

  • Stop the server service
  • Load the old databases separately in version 15 in the client DIRECTLY
  • Click on Database -> Save as and save the database in .pswe format
  • Delete all user-defined icons (Delete properties -> symbols)
  • Delete the history (Properties -> Extended -> Delete Password History)
  • Finally, convert large attachments into the "Document" format manually.

2) Convert attachments

Delete attachments from your database and convert them into the newer type of entry "Document". To do so, go to Extras -> Clean and uncheck all checkboxes except "With attach greater than" and enter 1 in the field to the right of it. All attachments will now be displayed. Save them locally and delete them afterwards. Create a new type of entry called "Document" and insert the saved attachment there.

Repeat this process until all attachments are available as documents.

Especially for databases with many attachments, this cleanup can lead to massive performance gains.

3) History

Disable password history if you don't actually need it. To do so, click Properties -> Advanced and deactivate "Save history of password changes".

4) Compression

Consider compressing the database.

Compression/decompression requires additional time for loading/saving.

We recommend the following:

  • For local databases - do not use compression
  • For Cloud Databases - Use Compression
  • For databases on the server - compression can be useful for large databases. For smaller systems there are hardly any performance advantages.

 To enable compression, go to "Properties" and enable "Use compression to reduce database size".

5 out of 5 found this helpful

Comments

0 comments

Please sign in to leave a comment.