Data Access

•	Sequential files can be created in memory. If you need a temporary sequential file there is no need to create it on disk. You can obtain better performance by creating the file in memory. The syntax to define a memory file is:

INPUT-OUTPUT SECTION. FILE-CONTROL. select my-file assign to address memory-area   .... WORKING-STORAGE SECTION. 77 memory-area pic x any length.

•	In thin client it’s better to call C$LOCKPID instead of using the BaseLockManager if you need to know who’s locking a record.

•	The files that are used very often should reside on a solid-state drive (SSD) or a RAM disk.

The following suggestions are applicable to c-treeRTG:

•	Use the latest c-tree version available.

•	Increase the values of IDX_MEMORY and DAT_MEMORY in ctsrvr.cfg.

•	Enable the SHAREMEM protocol in ctsrvr.cfg, if not yet enabled.

•	Take advantage of prefetch and batchaddition where applicable (see <batchaddition> and <prefetch> for details).

•	Avoid the use of a file connector, if possible.

•	For temporary files, memory files should be used (see <memoryfile>).