Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows systems - is file fragmentation bad?
Message
From
02/01/2003 04:17:01
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
To
02/01/2003 02:09:23
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00736741
Message ID:
00737258
Views:
25
>Typically, you seldom want to read a entire table, but only a part of it. In a OLTP environment with lots of writes (inserts) in different tables fragmentation naturally occurs in the first available clusters, causing fragmentation. For write purposes this is not any problem, and in fact it is the most effective manner to do inserts.

"Some" (most ?) DBMS more or less manage their own space within "pre-allocated" database space, which may be further extended at run time.

"Fragmentation" is not necessarily a given in OLTP environments.

For that matter, even DBF's could be "pre-allocated" and the (initial) empty space recycled if one was really concerned about fragmentation.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform