Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows systems - is file fragmentation bad?
Message
 
To
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:
00738343
Views:
19
>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,

I understand perfectly. My position remains as stated.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform