23 Nov
2008
23 Nov
'08
12:05 p.m.
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.
Sadly the 49GB table will also not insert without foreign keys. Stefan