[BioSQL-l] Re: [Open-bio-l] FK cascades

[Lincoln Stein]

On Thursday 22 August 2002 01:46 am, Chris Mungall wrote:
> I don't know enough about InnoDB to comment. we're still using myisam at
> berkeley coz we haven't had time to look into changing. how does it
> compare speed-wise to MyISAM?

In my hands, about a 2x penalty hit in selects; 5-10x penalty on inserts and 
updates.

Lincoln

-- 
========================================================================
Lincoln D. Stein                           Cold Spring Harbor Laboratory
lstein@cshl.org			                  Cold Spring Harbor, NY
========================================================================