On 11-1-2012 14:21, moeswede@... wrote:
filesystem
blocksize. The default for NTFS is 4k, so this is also good for Progress.
But you can also use 8k or more for Progress, if you are comfortable with
reformatting the NTFS filesystem that stores the database accordingly.
Be aware that many Progress tuning parameters take database blocksize as
a unit.
Some users see a performance improvement when they change the blocksize from
4k to 8k, when in fact the biggest change is that the -B parameter (amount
of buffering) doubles effectively. The same can be achieved with just
doubling
the tuning parameter, and leaving the database as is.
Pim
> Progress recomend the following block sizes:Actually they recommend that the database blocksize be equal to the
>
> Unix 8192
> Linux 4096
> Windows 4096
filesystem
blocksize. The default for NTFS is 4k, so this is also good for Progress.
But you can also use 8k or more for Progress, if you are comfortable with
reformatting the NTFS filesystem that stores the database accordingly.
Be aware that many Progress tuning parameters take database blocksize as
a unit.
Some users see a performance improvement when they change the blocksize from
4k to 8k, when in fact the biggest change is that the -B parameter (amount
of buffering) doubles effectively. The same can be achieved with just
doubling
the tuning parameter, and leaving the database as is.
Pim