Subject Re: [firebird-support] Re: Bad surprise on performance
Author André Knappstein
Thank you very much for the advice, Hannes.

I did not think of this too well. But of course this sounds very
logical. I will re-configure the server to match the most popular
database page size (I have 6 different databases).

I will first consult different papers I have from conferences
and some available other documentation, and then decide what will be a
good page size for my scenario after the migration.


Ihre Nachricht:
> Guten Tag André Knappstein Knappstein@... [firebird-support],

> am Samstag, 3. Januar 2015 um 10:45 schrieben Sie:

>> Stripe size is 64K, btw.
> much too big , best size for a stripset ist same as DB Page Size

> Strip Set 64Kb means that the controller will read and write Blocks of 64KB each I/O operation
> with a page size of 4 KB 60 KB are moved around with no use ,
> wasting more then 90 percent of the disk read/write bandwidth
> (disk caches will reduce the impact somewhat)

> my LSI Controller allows me a stripeset as small as 16kb , so it set my page size to match