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

Lincoln Stein lstein@cshl.org
Mon, 26 Aug 2002 11:45:14 -0400


It's going to depend heavily on the application.  This is on Bio::DB::GFF 
which uses lots of indices to handle positional queries.

Lincoln

On Thursday 22 August 2002 02:02 pm, Hilmar Lapp wrote:
> 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
> > ==============================================================
> > ==========
>
> _______________________________________________
> Open-Bio-l mailing list
> Open-Bio-l@open-bio.org
> http://open-bio.org/mailman/listinfo/open-bio-l

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