Application Engine ReUse Statement in PeopleSoft

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

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

相关阅读

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

相关 Using Oracle Index Hints in SQL statements

Using Oracle Index Hints in SQL statements Hints are used to give specific information

向右看齐/ 2022年08月02日 05:44/ 0 赞/ 131 阅读

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

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

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

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

相关 Server Error in '/' Application

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

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

相关 Debugging Functionality in Peoplesoft

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

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

相关 Application Engine Actions

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

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

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

相关 Call Query from Application Engine

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

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

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