[702] in Moira
Re: query get_ace_user() "RUSER"
daemon@ATHENA.MIT.EDU (Mark Rosenstein)
Thu Feb 3 15:09:41 1994
Date: Thu, 3 Feb 94 15:08 EST
From: mar@actwin.com (Mark Rosenstein)
To: darrin@MIT.EDU
Cc: bug-moira@MIT.EDU, kim@MIT.EDU, darrin@MIT.EDU, tom@MIT.EDU, tytso@MIT.EDU
In-Reply-To: <9402031943.AA22906@imbrium.MIT.EDU> (message from Darrin E. Robinson on Thu, 03 Feb 94 14:43:38 EST)
From: Darrin E. Robinson <darrin@MIT.EDU>
A user just ran this query and has the database tied up. It's
already taking 21 minutes. Should we consider acl'ing this query
so that people don't run it.
I suspect that there's an index missing on a table somewhere. This
query should finish in a reasonable time. It still takes longer than
most queries, but should take no more than a minute or so.
An index could be missing because this query looks things up
differently from all other queries, and may not have been fully
exercised since the Ingres upgrade. I know we had trouble with it in
the old vesion of Ingres when it was first written, but eventually got
it running fairly quickly.
To find out what part is taking so long, ON THE TEST MOIRA SERVER turn
on query debugging "query _sdl 87", then perform the query in question
and then look at the huge log produced. Since every line is
timestamped, you can figure out which part is slow.
-Mark
