Re: Finding queries which result in sequential scans

On Tue, 18 May 2004 12:22:55 -0400, rkusenet wrote: > "John Hardin" <johnh@aproposretail.com> wrote > >> ...but running this once per minute has an unfortunate tendency to >> eventually crash the engine... > > what !!! > I use 9.21 which is far less stable than later versions and I have > used this query every 5 seconds. The engine never crashed. How can you be > so certain that this query crashes the engine. Because when I stopped running it the engine stopped crashing... >> I was thinking it would be a better idea to write a trigger on >> syssqexplain that would write the query info to another table - that way >> it's only getting written once, and the overall process is a lot >> lighter-weight. > > sysmaster does not support triggers. It is not a real database. It is > a pseudo database only. Thought so. Thanks for confirming. -- John Hardin KA7OHZ <johnh@aproposretail.com> Internal Systems Administrator voice: (425) 672-1304 Apropos Retail Management Systems, Inc. fax: (425) 672-0192 ----------------------------------------------------------------------- Failure to plan ahead on someone else's part does not constitute an emergency on my part. - David W. Barts in a.s.r