correction: re: dna_homol in sequence class

Dave Matthews matthews at
Tue Sep 3 11:09:35 EST 2002

Oops.  Overextrapolated and undertested.  I said,

> select a from a in object ("sequence", "Em:AC104662")
> is a _lot_ faster than
> select a from a in class sequence where a = "Em:AC104662"

Actually both of those are essentially instantaneous.  The difference comes
with a little more complicated case:

select a from a in object ("sequence", "Em:AC104662")->DNA_homol  

takes < 1 sec, whereas

select a from s in class sequence, a in s->DNA_homol where s = "Em:AC104662"

takes 110 sec.

(This is with ace4_9i and a database with 500,000 Sequence records.)

- Dave

More information about the Acedb mailing list