Project:
| View Revisions: Issue #33875 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0033875: Importing/Exporting sample data using PostgreSQL's COPY instead of current XML | ||
| Revision | 2016-12-02 08:41 by alostale | ||
| Description | Currently we use XML to export and import Openbravo's sampledata. To export we extract the database contents ourselves and then use ddlutil's DataWriter to export them to database. To import we use the DataReader, that parses the XML en loads the data in the database. PostgreSQL provides the COPY command [1], using it would have at least two advantages: - The exported sample data is much smaller since the CSV format has less overhead that XML (one particular uncompressed sampledata weighted 4.5G in XML versus 1.2G in CSV, 147M vs 127M compressed). - Both the export and import process are much faster. Metrics will be added here when they are available. Project: http://wiki.openbravo.com/wiki/Projects:Import_Export_Sample_Data_Using_PostgreSQL_Copy [^] [1] https://www.postgresql.org/docs/9.5/static/sql-copy.html [^] |
||
| Revision | 2016-11-30 17:03 by alostale | ||
| Description | Currently we use XML to export and import Openbravo's sampledata. To export we extract the database contents ourselves and then use ddlutil's DataWriter to export them to database. To import we use the DataReader, that parses the XML en loads the data in the database. PostgreSQL provides the COPY command [1], using it would have at least two advantages: - The exported sample data is much smaller since the CSV format has less overhead that XML (one particular uncompressed sampledata weighted 4.5G in XML versus 1.2G in CSV, 147M vs 127M compressed). - Both the export and import process are much faster. Metrics will be added here when they are available. [1] https://www.postgresql.org/docs/9.5/static/sql-copy.html [^] |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |