Application Engine ReUse Statement in PeopleSoft

比眉伴天荒 2021-11-13 18:18 216阅读 0赞

The ReUse in Application Engine was brought to my attention by a great blog that I follow regularly. The original post can be found at http://peoplesofttipster.com/2007/07/31/reuse-in-app-engines/.

The ReUse statement setting on an Application Engine is a great way to increase performance. It’s useful when you have a SQL object that is called multiple times, for instance when you have a DoSelect that runs a SQL Step repeatedly, substituting different Bind variables in each time.

The default setting for ReUse is ‘No’, which means that each time the SQL Step is called it is recompiled and new execution plan generated, bad news if the SQL has to run a large number of times. If the ReUse setting is ‘Yes’ then any %Binds in the SQL statement are converted into ‘:1’, ‘:2’ etc. This means the statement can just be compiled once and the same plan used each time, resulting in really quite dramatic improvements in processing time.

转载于:https://www.cnblogs.com/GoDevil/archive/2008/08/26/1276670.html

发表评论取消回复

表情：

评论列表（有 0 条评论，216人围观）

还没有评论，来说两句吧...

相关阅读

相关 7 Steps to Setup A Record Level Audit in PeopleSoft

Record level Auditing As the name suggests, record level auditing is the auditin...

小灰灰/ 2024年04月17日 05:22/ 0 赞/ 67 阅读

相关 peoplesoft链接oracle,Oracle OAM实现PeopleSoft SSO单点登录

/\----peoplesoft sso-----\/ Function Oracle\_Access\_Manager\_Authentication() /\ Note

怼烎@/ 2023年01月18日 06:37/ 0 赞/ 153 阅读

相关 Custom Depth in Unreal Engine 4

Posted on [September 14, 2014][September 14_ 2014] by [Tom][] Unreal Engine 4 i

阳光穿透心脏的1/2处/ 2022年07月13日 07:15/ 0 赞/ 82 阅读

相关 PeopleSoft技术(Application Designer学习，简称AD)

本篇学习FIELD、RECORD、COMPONENT、PAGE、MENU的基本含义，和在AD中怎样创建。一、开发过程概览设计阶段：用户需求定义->security设

青旅半醒/ 2022年05月28日 00:13/ 0 赞/ 280 阅读

相关 Server Error in '/' Application

Many articles are discussing about advantages of using Session StateServer or SQLServer

比眉伴天荒/ 2022年01月11日 08:19/ 0 赞/ 177 阅读

相关 Debugging Functionality in Peoplesoft

Open Configuration Manager -> Profile ->Create. • Select Connection Type as Applicatio

川长思鸟来/ 2021年12月15日 02:53/ 0 赞/ 211 阅读

相关 Application Engine Actions

Specifying SQL Actions ReUse Statement Property The ReUse Statement property is availa

古城微笑少年丶/ 2021年12月15日 02:51/ 0 赞/ 280 阅读

相关 PeopleSoft Audit

Same way as a delivered record (or you can add audits to a delivered record if it doesn'

今天药忘吃喽~/ 2021年11月13日 18:34/ 0 赞/ 274 阅读

相关 Call Query from Application Engine

Function SG\_ExecQuery() Returns boolean; Local string &sOutFile; Local Record

曾经终败给现在/ 2021年11月13日 18:24/ 0 赞/ 197 阅读

相关 Application Engine ReUse Statement in PeopleSoft

The ReUse in Application Engine was brought to my attention by a great blog that I follo

比眉伴天荒/ 2021年11月13日 18:18/ 0 赞/ 217 阅读