Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows systems - is file fragmentation bad?
Message
From
06/01/2003 02:10:11
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00736741
Message ID:
00738311
Views:
18
George,

>>But again this is an academical question because:
>>1. We don't have much control how files should be fragemented
>>2. With HD and OS chaching it is difficult to measure these things.
>>3. With RAID controlers or tables stored on differen HDs, seek time schemes get more complicated to determine.
>>

>I disagree. We do have control over whether or not a file is fragmented by doing periodic file maintenance. I pointed this out in my second post to Jim that I referenced above. He pointed out that Windows will try to produce an unfragmented file when it is written. By re-creating tables and indexes we have a degree of control over this.

Please read carefully. I've acknowledge this point to JimN a long time ago. I said: We don't have much control of how files should be fragmented. It seems there is nothing to disagree on here.

>OTOH, hoping that you'll get better performance with fragmented files gives you no control.

>Let's leave it at this. We have a difference of opinion. I respect your's, and I hope that you'll respect mine. I assume that you're comfortable with your's. I know I'm confortable with mine.

I think I do understand your position and its really not that different from mine. OTOH, I get the impression you don't understand (or don't want to understand) my standpoint in identyfying cases where logical unfragmented dossiers are better.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform