Re: Tuning Question

From: Ross Mohan <rmohan_at_ix.netcom.com>
Date: Wed, 3 Feb 1999 10:38:30 -0500
Message-ID: <799qij$lks$1@paxfeed.eni.net>

OK, that's good. Let's say that *is* the problem.

How to tune ( other than the obvious 'reduce the recordset' ) ...that is, can we set up Forms to act better?

Piotr Kolodziej wrote in message <78pvcs$o79$1_at_korweta.task.gda.pl>...
>xx wrote in message <78pton$6ii_at_romeo.logica.co.uk>...
>>I am running an SQL statement using sqlplus and it takes about
>>1.9 seconds to complete. In Forms 4.5 I build the same SQL statement and
it
>>takes 2 min 46 seconds to complete. [cut]
>>The explain plan is the same in both instances.
>
>
>What's the type of statement ? Query returning hundreds or thousands of
rows
>and stored in a block? If so, the problem may be buffering of returned rows
>by Forms.
>
>--
>Piotr Kolodziej pkol_at_otago.gda.pl
>Just my private opinion.
>
Received on Wed Feb 03 1999 - 09:38:30 CST