[BioSQL-l] trouble cramming genbank

[Hilmar Lapp]

On Tuesday, November 5, 2002, at 01:41 AM, Elia Stupka wrote:

>> The FKs don't slow down look-up. Disabling them temporarily is just an
>> option to manually speed up bulk loads and needs to be documented at
>> some point for those users who want to load 20 Mio records over night.
>
> Sounds good... so is it just a matter of disabling FKs or also
> "disabling" some code?
>

The only code that relies on the FK constraints being enforced is 
the one that deletes. If you want to bulk load and delete at the 
same time, disabling the FK constraints is not the best idea, but 
load & delete in bulk is not going to be fast anyway.

>> My DEM 0.02 on this (yeah invalid pennies :-)
>
> my 2 italian liras (definitely very invalid) :)

When did those cease to exist? I've still got 500+100 lira coins, 
but for anything less in exchange I got only sweets :-))

	-hilmar
--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------