in reply to Defragmentation of a BTREE DB_File

In a database, you don't really delete a record, you simply mark it deleted. Depending on the system you are using, that disk space might then be re-used for a new record, or it might sit, wasting space. In that sense, you might need to re-pack a database on occassion.

Convenional defragmentation, on the other hand, is not only a filesystem concern, but a Microsoft concern. It does not apply to Unix file systems. That's why you have to de-frag MS file systems, but there's no such utility for Unix.

--
TTTATCGGTCGTTATATAGATGTTTGCA

Replies are listed 'Best First'.
Re^2: Defragmentation of a BTREE DB_File
by Aristotle (Chancellor) on Dec 31, 2003 at 17:35 UTC
    Well, really, it's a concern for FAT filesystems, not even Microsoft filesystems in general. NTFS does tend more to fragmentation (and generally behaves a bit worse in most aspects) than the Unix filesystems it resembles, but it is hardly an issue even then.

    Makeshifts last the longest.