View Revisions: Issue #880

Summary 0000880: Optimize database backup/restore process
Revision 2017-10-13 14:31 by rijkr
Description IST: When creating database backup, XML is built in memory before writing to file. For large data sets this can lead to OutOfMemoryError exceptions.
SOLL: Use XMLStreamWriter to write the backup file.
Revision 2017-10-14 17:50 by rijkr
Description IST: When creating database backup, XML is built in memory before writing to file. For large data sets this can lead to OutOfMemoryError exceptions. Likewise, when restoring the database from XML backup, XML is read into memory before inserting the database rows.
SOLL: Use XMLStreamWriter to write the backup file, use XMLStreamReader to read it.
Revision 2017-10-23 12:31 by rijkr
Description IST: When creating database backup, XML is built in memory before writing to file. For large data sets this can lead to OutOfMemoryError exceptions. Likewise, when restoring the database from XML backup, XML is read into memory before inserting the database rows.
SOLL: Use XMLStreamWriter to write the backup file, use XMLStreamReader to read it.

Revision 2017-10-13 14:31 by rijkr
Additional Information
Revision 2017-10-23 12:31 by rijkr
Additional Information The backup results in non-indenting XML. When inspecting the XML, use
xmllint --format
to indent ad-hoc.
Revision 2017-10-23 12:33 by rijkr
Additional Information The backup results in non-indenting XML. When inspecting the XML, use <code>xmllint --format</code> to indent ad-hoc.
Revision 2017-10-23 12:35 by rijkr
Additional Information The backup results in non-indenting XML. When inspecting the XML, indent ad-hoc with
xmllint --format
.
Revision 2017-10-23 12:35 by rijkr
Additional Information The backup results in non-indenting XML. When inspecting the XML, indent ad-hoc with:
xmllint --format