Martin Kersten wrote:
> For large table loads (relative to the swap size) it is advisable to 
> load in multiple steps.
> First load the data into the tables without (foreign) key checks.
> After this step ALTER the tables to respect the (foreign) keys.


I don't know if it was the swap space or the removing of *all* 
constraints including primary keys. But I have the tables inside MonetDB 
:) I'm happy :) Now adding constraints :)


Stefan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-developers mailing list
Monetdb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Reply via email to