| David Kerber 2005-06-13, 7:23 am |
| In article <42ad7db3.dcc.1681692777@sybase.com>, Napoli says...
> When I start up my database in the consol window it says
> that the .db file consists of xxxxx number of Disk
> Fragments. Is this normal? If not how do I eliminate the
> fragments? Also does it effect performance? Any other tips
> one can give on routine maintanence would be great.
The number of fragments your database file has been stored in on disk
can affect your performance a bit, and it happens as the file enlarges
over its life. Shutting down the database engine and running a disk
defragmenter is how you get rid of it. I wouldn't worry about the
performance hit if the number of fragments is in the single-digit or low
double-digit range. If you get up to hundreds or thousands, it's time
to defrag the disk though...
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
|