[Treebase-devel] Sample output from our table dumper

[Mark D. <mjd...@ge...>]

Hilmar:

The program we are writing that dumps out data from our DB2 database is 
not complete, but Val suggested that we send you some sample output so 
that you can see if it is what you wanted.

Unless you say otherwise, the output will all look substantially like 
the attached file.

As you may recall, there is one gigantic table, MATRIXELEMENT, with 
around 3e8 records and about 25.8 gb of data.  I have not tried dumping 
this yet.

But the next-largest table is MATRIXCOLUMN, with 5.6 million records and 
310 MB of data.  The dumper takes 7 minutes to write the compressed dump 
file, which takes up 32 MB.

If the MATRIXELEMENT table behaves similarly, it will take around 5.5 
hours to write and will take up a mere 2.6 GB, so transferring it will 
not be as big a job as we feared.