Selection Performance
The mass mailing and call campaign assistants are tools that can potentially be used to manipulate very large volumes of data.
In view of these volumes, two specific requirements must be met:
1 / The selections must be executed within the shortest time possible.
2 / Support of any sample generation must be guaranteed without any maximum volume constraint.
To achieve these objectives, the assistants carryout two major actions.
They truncate a request into several smaller, successive requests. This makes it possible to manage samples without any volume constraint.
They group the transactions. This leads to a noticeable improvement in the performances.
This parameter is used to influence the breakdown of requests and the grouping of transactions carried out during the generation of marketing samples.
In the great majority of cases, the default value of 500 is perfectly satisfactory and does not require modification.
The entry of a lower value can be imposed by the definition of very small "rollback segment" sizes at the level of a database using stable cursors.
Level of localization / Global variable
This parameter is defined at the level Folder. It belongs to Chapter SUP (Supervisor) and the Group MIS (Miscellaneous), The following parameters are also associated with this chapter and group :
- ALMADOS (Almacom identifier)
- ASDAUSFAC (Cnx user - email optional)
- ASDTRTAPP (Sdata application processing)
- ASWLIMIT (Limit size of result)
- ATXTSRV (Development)
- AYTFCYWRK (Current website)
- CHGTYP (Rate type)
- DEFCUR (Default currency)
- DUPCNTNAME (Duplicate contact authorized)
- EECTYPCUR (Intrastat currency rate type)
- EURORND (Euro conversion rounding)
- IVA (Italian legislation)
- MIGTRACE (Migration by flow log)
No global variable is associated with it.