Re: Slow response of forms

From: mRangel <marcus.rangel_at_gmail.com>
Date: 31 Aug 2006 12:45:09 -0700
Message-ID: <1157053508.988463.195250@m79g2000cwm.googlegroups.com>

> This does not have any count(*) ...can you please suggest some thing
> here.
> I executed the above mentioned query manually from sql prompt and it
> was very fast.

Raj, did you realize that in both your examples you have the timing for 20 executions of the query, instead of one ? This is where the difference between forms and sqlplus is coming from. You need to review your queries and make them faster, forms have nothing to do with it. Can you send us the execution plan for the last one ?

[]´s
Rangel Received on Thu Aug 31 2006 - 14:45:09 CDT