IUBio

AQL problem with "diff"

Dave Matthews matthews at greengenes.cit.cornell.edu
Wed Jun 5 03:32:06 EST 2002


If I do a 'simpler' diff,

aql @A := \
(select S from S in class Sequence) \
diff \
(select S from S in class Sequence)

the server hangs, and stays hung when I kill the client.  Won't accept any
new connections.  Uses all the cpu, not much memory.  (So please kids if
you're trying this from home let me know you're doing it so I can restart the
server.)

Is this because this simpler diff is 150K x 150K records?  
If I do the equivalent thing in xace, a MINUS between two copies of the 
keyset, it's instantaneous.

- Dave

---





More information about the Acedb mailing list

Send comments to us at biosci-help [At] net.bio.net