AQL problem with "diff"

Dave Matthews matthews at
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

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