Home » Developer & Programmer » Reports & Discoverer » which is fastest, sql in afterform trigger or database procedure
which is fastest, sql in afterform trigger or database procedure [message #89578] Tue, 25 May 2004 00:12 Go to next message
kil
Messages: 10
Registered: April 2004
Junior Member
Will a sql statement run faster if it's in a database procedure, rather than in the afterform trigger in the report ?

I got a report, where some data are selected in the afterform trigger, but thought it might be faster to put it into a database procedure instead.

Regards

Kim

 
Re: which is fastest, sql in afterform trigger or database procedure [message #89581 is a reply to message #89578] Tue, 25 May 2004 22:01 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Db proc will be faster.

Regards
Himanshu
Previous Topic: Static LOV in Oracle Discoverer
Next Topic: 6i Error
Goto Forum:
  


Current Time: Mon Mar 04 12:13:41 CST 2024