4D v16.3Get table fragmentation |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v16.3
Get table fragmentation
Get table fragmentation
The Get table fragmentation command returns the percentage of logical fragmentation for the records of the table designated by the aTable parameter. The rate of logical fragmentation of the records indicates whether the records are stored in an ordered manner in the data file. If the fragmentation becomes too high, this can considerably slow down sorts and sequential searches on the table. A fragmentation percentage of 0 corresponds to no fragmentation. Beyond a rate of 20%, it may be useful to compact the data file. This maintenance method lets you request the compacting of the data file in the case where there is considerable fragmentation in at least one table of the database: ToBeCompacted:=False
See also
|
PROPERTIES
Product: 4D HISTORY
Created: 4D v12 TAGS Fragmentation ARTICLE USAGE
4D Language Reference ( 4D v16) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||