Home » Developer & Programmer » Forms » SQL Vs Oracle Forms Performance issue (SQL 10.2.0.1.0 Forms 6.0.8)
SQL Vs Oracle Forms Performance issue [message #678399] Sat, 30 November 2019 04:59 Go to previous message
bluetooth420
Messages: 141
Registered: November 2011
Senior Member
Hello,

A simple query is giving result in few seconds while same query is giving result in Oracle Forms in 20 seconds. (The query is being used in when validate item in order to populate the balance).

Here are are the both codes.
in SQL
SQL> select balance  from v2cust where ccode=153;

   BALANCE
----------
     .8792

in Oracle Froms

message(2.1); pause;
Select balance 
	into :block1.d_ob
	from v2cust
	where ccode = :block1.ccode;
message(2.2); pause;


What am i missing?

Kindly help
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: LOV buttons do not show questioning, but ellipsis
Next Topic: LOGON function
Goto Forum:
  


Current Time: Mon Dec 09 20:56:36 CST 2019