Slow response from FORMS query

From: Andy Horne <ahorne_at_netspace.net.au>
Date: 1996/11/28
Message-ID: <329CD36A.7707_at_netspace.net.au>#1/1


A developer brought me some SQL which she said was running slowly, so I set a trace on and yep, it was. I then ran it myself 'stand-alone' and it
came back straight away. She ran it 'stand-alone' with the same result. However, when it is run through FORMS it slows down (104 secs as opposed to about .25 sec).
What is FORMS doing to cause this? Can I change anything to improve it?

Thanks,

Andy Horne Received on Thu Nov 28 1996 - 00:00:00 CET

Original text of this message