Subject | R: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2 |
---|---|
Author | Costantino Molinari |
Post date | 2014-09-29T15:22:23Z |
Dear Hannes,
good suggestion, but changing the stripe size is not for me now, if I don't
want to install all again, if I'll be able to obtain an acceptable speed
with other settings.
-----Messaggio originale-----
Da: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Inviato: lunedì 29 settembre 2014 14:52
A: 'Costantino Molinari' c.molinari@... [firebird-support]
Oggetto: Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
Guten Tag 'Costantino Molinari' c.molinari@... [firebird-support],
Not surprisiing at all, Stripe Set is the amount of Data a RAID moves for
every read/write so if you have 16 KB or 4KB you still move 64KB each time
but with much less usable Payload per transfer go for a Stripsetsize of 16
KB and a Pagesize of 16KB for best match
--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.
Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
good suggestion, but changing the stripe size is not for me now, if I don't
want to install all again, if I'll be able to obtain an acceptable speed
with other settings.
-----Messaggio originale-----
Da: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Inviato: lunedì 29 settembre 2014 14:52
A: 'Costantino Molinari' c.molinari@... [firebird-support]
Oggetto: Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
Guten Tag 'Costantino Molinari' c.molinari@... [firebird-support],
> To Karol:just as my NTFS cluster size and time incredibly doubled !!
> Original page size was 16K, than I changed page size to 4K
> Really confused, but maybe it has to do with the 64K stripesize of RAID 10 .
Not surprisiing at all, Stripe Set is the amount of Data a RAID moves for
every read/write so if you have 16 KB or 4KB you still move 64KB each time
but with much less usable Payload per transfer go for a Stripsetsize of 16
KB and a Pagesize of 16KB for best match
--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.
Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links