Re: compress/compact database?

From: Sander <sander_at_example.com>
Date: 02 May 2002 21:19:31 GMT
Message-ID: <Xns9202ED428889guhvftbhqfjnneqpk@194.109.133.20>

"Sergey Adamenko" <adamenko_at_i.com.ua> wrote in news:aarks6$2eeo$1_at_news.dg.net.ua:

> If your datafiles are stored on NTFS partition under NT/W2000, you
> can set 'Compressed' attribute for your datafiles.
> I do so when working with some of my testing DB: Oracle work
> pretty good. But there is performance cost you would pay when
> intensive WRITE-to-datafiles operations will occure. Later this
> will cause considerable fragmentation on the OS partiotion.

Of course, since the OS will have to decompress the datafile before it can use it. With large files this will give you a bad performance.

Sander Received on Thu May 02 2002 - 16:19:31 CDT