ttCompact

Description

Compacts the data store. ttCompact compacts both the permanent and temporary data partitions.

Call ttCompact periodically to reorganize the internal structure of a data store. It may also be useful to call ttCompact when the application receives out of memory errors because the cause of the problem may be data store fragmentation.

ttCompact merges adjacent blocks of free space, but does not move any items that are allocated. Therefore, fragmentation that is caused by small unallocated blocks of memory surrounded by allocated blocks of memory is not eliminated by using ttCompact. To eliminate this type of fragmentation, consider using ttMigrate -rebuild. (See "ttMigrate").

Required privilege

This procedure requires the ADMIN privilege.

Syntax

ttCompact()

Parameters

ttCompact has no parameters.

Result set

ttCompact returns no results.

Example

CALL ttCompact;

Note

Compacting data does not modify result addresses.