Re: db_block_size and performance

What would be the OS blosck size for Windows NT 4.0 sp3?

On Thu, 29 Oct 1998 08:20:20 -0500, Chuck Hamilton <chuckh_at_safeaccess.net> wrote:

>This is a cryptographically signed message in MIME format.
>
>--------------ms2D5D5302EEACB6E548D9A388
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>>
>> There is no hard and fast rule about how big a db_block_size to use. It
>> depends on your application.
>
>Actually there is one hard and fast rule -- make sure the block size is a
>multiple of the OS block size. Otherwise you'll end up issuing multiple OS calls
>to read the same physical block of data.
>
>We had an OLTP Oracle database running on Netware. It was installed with the
>default 2k block size even though the OS block size was 8k. We increased the DB
>block size to 8k and saw a significant performance increase.
>
> Chuck Hamilton
>
>--------------ms2D5D5302EEACB6E548D9A388
>Content-Type: application/x-pkcs7-signature; name="smime.p7s"
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment; filename="smime.p7s"
>Content-Description: S/MIME Cryptographic Signature
>
>MIIHpgYJKoZIhvcNAQcCoIIHlzCCB5MCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
>BckwggKIMIIB8aADAgECAgJGPDANBgkqhkiG9w0BAQQFADCBuTELMAkGA1UEBhMCWkExFTAT
>BgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRo
>YXd0ZSBDb25zdWx0aW5nMSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAx
>Nzo1NTE2MDQGA1UEAxMtVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5
>OC45LjE2MB4XDTk4MTAyNzE3MTQyNFoXDTk5MTAyNzE3MTQyNFowRzEfMB0GA1UEAxMWVGhh
>d3RlIEZyZWVtYWlsIE1lbWJlcjEkMCIGCSqGSIb3DQEJARYVY2h1Y2toQHNhZmVhY2Nlc3Mu
>bmV0MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALKGbsEBBYR8bbdnNn5i/v2q29pixSiPshCO
>R9qFgkeJPv4Gpv8NApxGz/Kf+RkJbi88+PlMuLssSLJhber5lXMCAwEAAaNUMFIwEQYJYIZI
>AYb4QgEBBAQDAgWgMA4GA1UdDwEB/wQEAwIFoDAMBgNVHRMBAf8EAjAAMB8GA1UdIwQYMBaA
>FP4+YJxrjA+w2DPGysYeWLBxOLXgMA0GCSqGSIb3DQEBBAUAA4GBADN4ltaKS0WYAGaWTZ+0
>tjb9w3dJ3hs6nw26HZx3uabGsrBB2CXFrx0RgMugbn4eK93XVzLtmtPO0Lkf59FKN5BmpK5s
>0Goe7smMP3q7MOfr9NdYwuK6z8HYEbkZ4qnmdKcfW5hPCtSeMK0v8ArLRjS+35eRgdSb5qx9
>QWiCZfdFMIIDOTCCAqKgAwIBAgIBCjANBgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkEx
>FTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFU
>aGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZp
>c2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcN
>AQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk4MDkxNjE3NTUzNFoXDTAw
>MDkxNTE3NTUzNFowgbkxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDAS
>BgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UE
>CxMgVGhhd3RlIFBGIFJTQSBJSyAxOTk4LjkuMTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQ
>ZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWVyIDE5OTguOS4xNjCBnzANBgkqhkiG9w0BAQEF
>AAOBjQAwgYkCgYEAxKXl1NTQXwgC7gchfSS/q2uOHusgBwIVhGuP0JMkHxud7miyuSxP6ZNn
>FxAXHqH5Q0EjuTCqdpe78+f9gcC1MYv2plAmVPKVKOsZpB6XHrDiuJvBBJoy0DwJbE/kNU/w
>dr8AEwNPRQhg8/y00JABihLJnLp/UuoqkzU2PDzkNS8CAwEAAaM3MDUwEgYDVR0TAQH/BAgw
>BgEB/wIBADAfBgNVHSMEGDAWgBRyScJzNMZV9At2coF+d/SH58ayDjANBgkqhkiG9w0BAQQF
>AAOBgQAsx4IfAUM+B4/uaVypZIL4wJatkyvLm1DXQJqBwrqmdp08lUDcVcHhVYJ5qwopptUM
>4VcoPo/5u9XfDZNYqlsti48z5N1YFTV2chUpvUL0WpILd1+dJ9uaLU4bggaO0o1Wu5Xe2wxl
>Bd6VngLdUxe+vvxrwxoiehQrYb3Cn156WjGCAaUwggGhAgEBMIHAMIG5MQswCQYDVQQGEwJa
>QTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRQwEgYDVQQHEwtEdXJiYW52aWxsZTEaMBgGA1UE
>ChMRVGhhd3RlIENvbnN1bHRpbmcxKTAnBgNVBAsTIFRoYXd0ZSBQRiBSU0EgSUsgMTk5OC45
>LjE2IDE3OjU1MTYwNAYDVQQDEy1UaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgUlNBIElzc3Vl
>ciAxOTk4LjkuMTYCAkY8MAkGBSsOAwIaBQCgfTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcB
>MBwGCSqGSIb3DQEJBTEPFw05ODEwMjkxMzIwMjBaMB4GCSqGSIb3DQEJDzERMA8wDQYIKoZI
>hvcNAwICASgwIwYJKoZIhvcNAQkEMRYEFOw26K76xvErr+8IF07Q7usJk9eEMA0GCSqGSIb3
>DQEBAQUABEAZyNdEa0fXjczTpcg7Z+YA6a7QIFg2Xr1i3nba6LUgpAHCMF3OplKS6+WhYstF
>Nf6Jr2O9+ZKDqa2uQ8ua12hX
>--------------ms2D5D5302EEACB6E548D9A388--
>
Received on Tue Nov 03 1998 - 16:36:53 CST