Previous Topic

Next Topic

Book Contents
Setting the ChunkSize parameter in the InFormAdapter.Coding.config file

The ChunkSize parameter is the number of transactions that the InForm Adapter software looks at in a single coding get request call, and determines whether the PFEX_VERBATIMCACHE table needs to be updated based on new data, deleted data, or changed data in the InForm software. The ChunkSize parameter is set to 2000 by default.

In very large studies in which the PFEX_VERBATIMCACHE table is rebuilt (for example, when a new mapping is implemented) you might need to increase the value of the ChunkSize parameter. Increasing the value can improve performance of the PFEX_VERBATIMCACHE table rebuild if the verbatim density across the transactions in the study is not too high.

For example, in a very large study, transactions that contain verbatim information could be spread out over several thousand transactions. If the ChunkSize is set to 2000, each call made to the Adapter might update/insert only a few records. If the ChunkSize is set to 20000, each call will bring back many more verbatims. The disadvantage to this higher setting would occur in studies that have a high density of verbatims (such as if all 20000 transactions are from verbatim data). The call to the adapter could take a long time and potentially time out.

The value of the ChunkSize parameter is global to the InForm Adapter server and will affect all studies registered on that server.

To set the ChunkSize parameter:

Send Feedback