MAXSAVE (JANUS DEFINE parameter) - Revision history

JAL: remove displaytitle

2016-06-08T00:22:10Z

remove displaytitle

← Older revision		Revision as of 00:22, 8 June 2016
Line 1:		Line 1:
	~~{{DISPLAYTITLE:MAXSAVE}}~~
	<span class="pageSubtitle">MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests</span>		<span class="pageSubtitle">MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests</span>

	<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.		<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

	This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the <var class="product">[~~http~~:~~//sirius-software/maint/download/sdsr~~.pdf Specialty Data Store]</var> receives an SQL request from the <var class="product">Sybase Adaptive Server</var> it parses the request, translates it into <var class="product">User Language</var>, compiles the <var class="product">User Language</var> into quads and finally evaluates the compiled <var class="product">User Language</var>. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.		This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the <var class="product">[[Media:JsdsrNew.pdf\|Specialty Data Store]]</var> receives an SQL request from the <var class="product">Sybase Adaptive Server</var> it parses the request, translates it into <var class="product">User Language</var>, compiles the <var class="product">User Language</var> into quads and finally evaluates the compiled <var class="product">User Language</var>. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.

	The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.		The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.

JALWiccan: Automatically generated page update

2013-04-16T22:18:49Z

Automatically generated page update

← Older revision		Revision as of 22:18, 16 April 2013
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXSAVE}}		{{DISPLAYTITLE:MAXSAVE}}
	<span class="pageSubtitle"~~><section begin="desc" /~~>MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests~~<section end="desc" />~~</span>		<span class="pageSubtitle">MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests</span>

	<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.		<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

JAL2 at 21:40, 29 February 2012

2012-02-29T21:40:42Z

← Older revision		Revision as of 21:40, 29 February 2012
Line 2:		Line 2:
	<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests<section end="desc" /></span>

	<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port~~. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]]~~.		<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

	This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the <var class="product">[http://sirius-software/maint/download/sdsr.pdf Specialty Data Store]</var> receives an SQL request from the <var class="product">Sybase Adaptive Server</var> it parses the request, translates it into <var class="product">User Language</var>, compiles the <var class="product">User Language</var> into quads and finally evaluates the compiled <var class="product">User Language</var>. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.		This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the <var class="product">[http://sirius-software/maint/download/sdsr.pdf Specialty Data Store]</var> receives an SQL request from the <var class="product">Sybase Adaptive Server</var> it parses the request, translates it into <var class="product">User Language</var>, compiles the <var class="product">User Language</var> into quads and finally evaluates the compiled <var class="product">User Language</var>. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.

JAL2 at 21:26, 29 February 2012

2012-02-29T21:26:44Z

← Older revision		Revision as of 21:26, 29 February 2012
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXSAVE}}		{{DISPLAYTITLE:MAXSAVE}}
	<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx -- Max concurrent number of compiled SDS SQL requests.<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx — Max concurrent number of compiled SDS SQL requests<section end="desc" /></span>

	<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].		<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].

	This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the Specialty Data Store receives an SQL request from the Sybase Adaptive Server it parses the request, translates it into User Language, compiles the User Language into quads and finally evaluates the compiled User Language. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.		This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the <var class="product">[http://sirius-software/maint/download/sdsr.pdf Specialty Data Store]</var> receives an SQL request from the <var class="product">Sybase Adaptive Server</var> it parses the request, translates it into <var class="product">User Language</var>, compiles the <var class="product">User Language</var> into quads and finally evaluates the compiled <var class="product">User Language</var>. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.

	The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.		The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.

	Valid only for SDS (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and OAS) ports.		Valid only for <var>[[JANUS DEFINE#type\|SDS]]</var> (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and <var>[[JANUS DEFINE#type\|OAS]]</var>) ports.

	==~~References~~==		==See also==
			<ul>
			<li>[[List of Janus commands]]
			<li>[[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]]
			</ul>

	~~See: [[List of Janus commands]] \| [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].~~

	[[Category:JANUS DEFINE parameters\|MAXSAVE]]		[[Category:JANUS DEFINE parameters\|MAXSAVE]]

JALWiccan: 1 revision

2012-02-29T21:14:04Z

1 revision

← Older revision	Revision as of 21:14, 29 February 2012
(No difference)

JAL2 at 21:14, 29 February 2012

2012-02-29T21:14:02Z

← Older revision		Revision as of 21:14, 29 February 2012
Line 8:		Line 8:
	The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.		The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.

	Valid only for SDS (also known as OMNI and OAS) ports.		Valid only for SDS (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and OAS) ports.

	==References==		==References==

JAL2 at 19:04, 27 February 2012

2012-02-27T19:04:28Z

← Older revision		Revision as of 19:04, 27 February 2012
Line 2:		Line 2:
	<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx -- Max concurrent number of compiled SDS SQL requests.<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx -- Max concurrent number of compiled SDS SQL requests.<section end="desc" /></span>

	MAXSAVE is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].		<var>MAXSAVE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].

	This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the Specialty Data Store receives an SQL request from the Sybase Adaptive Server it parses the request, translates it into User Language, compiles the User Language into quads and finally evaluates the compiled User Language. When MAXSAVE is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps. The default for MAXSAVE of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.		This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the Specialty Data Store receives an SQL request from the Sybase Adaptive Server it parses the request, translates it into User Language, compiles the User Language into quads and finally evaluates the compiled User Language. When <var>MAXSAVE</var> is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps.

			The default for <var>MAXSAVE</var> of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.

	Valid only for SDS (also known as OMNI and OAS) ports.		Valid only for SDS (also known as OMNI and OAS) ports.

Admin: moved MAXSAVE to MAXSAVE (JANUS DEFINE parameter)

2011-12-06T23:15:13Z

moved MAXSAVE to MAXSAVE (JANUS DEFINE parameter)

← Older revision	Revision as of 23:15, 6 December 2011
(No difference)

Admin at 21:55, 11 March 2011

2011-03-11T21:55:48Z

← Older revision		Revision as of 21:55, 11 March 2011
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXSAVE}}		{{DISPLAYTITLE:MAXSAVE}}
	<span class="pageSubtitle"><section begin="desc" />xxx<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXSAVE xxx -- Max concurrent number of compiled SDS SQL requests.<section end="desc" /></span>

	MAXSAVE is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].		MAXSAVE is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].



	This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the Specialty Data Store receives an SQL request from the Sybase Adaptive Server it parses the request, translates it into User Language, compiles the User Language into quads and finally evaluates the compiled User Language. When MAXSAVE is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps. The default for MAXSAVE of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.		This parameter specifies the maximum number of compiled SQL requests to save in CCATEMP. When the Specialty Data Store receives an SQL request from the Sybase Adaptive Server it parses the request, translates it into User Language, compiles the User Language into quads and finally evaluates the compiled User Language. When MAXSAVE is greater than 0, compiled requests are saved and future identical requests (except for constants) can simply load the compiled requests from CCATEMP (much like an APSY load), bypassing the translation and compilation steps. The default for MAXSAVE of 16 should be adequate for most situations, ensuring that frequently run requests will perform well without wasting CCATEMP and I/O bandwidth for infrequently run requests.

Admin: 1 revision

2011-03-08T21:59:01Z

1 revision

← Older revision	Revision as of 21:59, 8 March 2011
(No difference)