Re: [Treebase-devel] Sample output from our table dumper

[Hilmar L. <hl...@du...>]

This looks great, except that each INSERT needs to be terminated by a  
semicolon.

Good news also on the file sizes, I'm pretty optimistic that we can  
work it this way.

Thanks for the update. Are you (or anyone else on this list, e.g.  
Rutger, Bill, or Val?) going to the Evolution Meetings this week?

	-hilmar

On Jun 10, 2009, at 3:30 PM, Mark Dominus wrote:

> 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.
>
> < 
> matrix 
> .gz 
> > 
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects_______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel

-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:- hlapp at duke dot edu :
===========================================================