>>I tried this in the CHATTER forum, but an absence of response prompts me to re-try here.
>>
>>Keeping in mind:
>>1) Modern Windows systems are multi-tasking systems.
>>2) Windows itself (and its components, like IE) make significant 'quiet' use of your HD space for all manner of files, large and small.
>>3) Other applications (MS Word for example) can use HD space 'quietly' too.
>>4) Modern HDs are fast, processors are faster yet, and RAM is plentiful.
>>... what hard facts are there to back up the axiom (it is essentially an axiom today) that fragmentation is bad?
>>
>>That fragmentation is bad is so prevalent a concept that I must be missing something obvious. What is it?
>>
>>Thanks for any/all input on this issue.
>
>Jim,
>While disk fragmentation is not as bad anymore because of the speed of hardrives, file fragmentation still is a problem no matter what.
>
>If a file is found in multiple places on the hard drive then it takes more than one drive revolution to retrieve the file. Even if the disk spins at 10K, having to make as many revolutions as there are fragments (possibly 500+) will chew up resources. This is bad.

Yes, I agree that that is bad. But really only in the case where the WHOLE FILE is wanted/needed for processing. Things like Word and Excel come to mind as such cases.

Now what about a database, with lots of tables, where specifically, it is a rare thing indeed to read a whole file? Include in your consideration that it is common for a database application to 'need' a record from a few files at a time (thus usually implicating some .CDXs and often .FPTs too). Any change in that situation?

By the way, my guess is that a Word or Excel file hardly has the chance to become fragmented because the whole is done in a single write, so there is virtually no chance for something else to intrude while it is written.

thanks (and hoping for more).

>
>Just my $0.02.