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

 

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 13:46:58 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.