[Open-bio-l] FK cascades

[Hilmar Lapp]

5-10x slower is pretty bad though. Where do the InnoDB conclude their claims from I'm wondering.

	-hilmar

> -----Original Message-----
> From: Lincoln Stein [mailto:lstein@cshl.org]
> Sent: Thursday, August 22, 2002 10:32 AM
> To: Chris Mungall; Hilmar Lapp
> Cc: biosql-l@open-bio.org; OBDA
> Subject: Re: [Open-bio-l] FK cascades
> 
> 
> 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
> ==============================================================
> ==========
>