Application Engine ReUse Statement in PeopleSoft

比眉伴天荒 2021-11-13 18:18 199阅读 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 条评论，199人围观）

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

相关阅读

相关 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 赞/ 63 阅读

相关 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 赞/ 65 阅读

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

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

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

相关 tf.AUTO_REUSE作用

概述在tensorflow中，为了节约变量存储空间，我们常常需要通过共享变量作用域(variable\_scope) 来实现共享变量。大家比较常用也比较笨

怼烎@/ 2022年05月13日 20:06/ 0 赞/ 160 阅读

相关 Server Error in '/' Application

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

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

相关 Debugging Functionality in Peoplesoft

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

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

相关 Application Engine Actions

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

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

相关 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 赞/ 261 阅读

相关 Call Query from Application Engine

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

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

相关 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 赞/ 200 阅读