Professional Web Applications Themes

Enable 32K Block in 8K Block DB - Informix

"Frank van Bortel" <net> wrote in message news:c4otl4$3fg$tilbu1.nb.home.nl...  Really Oracle benchmarks all use raw?...As an Informix person why did I used to keep hearing "according to Oracle raw devices are not faster, in fact filesystems are quicker" FROM MY CUSTOMERS than? ^^^^^^^^^^^^^^^^^^^^^^ Used to really annoy me...so Oracle have come around to my way of thinking than? As it's faster? What a suprise...   Dunno.  ...

  1. #1

    Default Re: Enable 32K Block in 8K Block DB


    "Frank van Bortel" <net> wrote in message
    news:c4otl4$3fg$tilbu1.nb.home.nl... 

    Really Oracle benchmarks all use raw?...As an Informix person why did
    I used to keep hearing

    "according to Oracle raw devices are not faster, in fact filesystems are
    quicker"

    FROM MY CUSTOMERS than?
    ^^^^^^^^^^^^^^^^^^^^^^

    Used to really annoy me...so Oracle have come around to my way of
    thinking than?
    As it's faster? What a suprise...

     

    Dunno.
     


    David Guest

  2. #2

    Default Re: Enable 32K Block in 8K Block DB


    "David Williams" <fsnet.co.uk> wrote in message
    news:c4stsg$h3$svr.pol.co.uk... 
    >
    > Really Oracle benchmarks all use raw?...As an Informix person why did
    > I used to keep hearing
    >
    > "according to Oracle raw devices are not faster, in fact filesystems[/ref]
    are 


    The discussion is not so much whether raw is faster or slower than a file
    system, on which the jury is still out. The issue here is: with a file
    system that does buffered I/O, am I free to choose any Oracle block size I
    like? (nope). Can I achieve performance gains by adopting multiple
    blocksizes within the one database? (nope).

    That's a completely different discussion than the one you seem to want to
    start.

    Regards
    HJR
    --
    -------------------------------------------
    Dizwell Informatics: http://www.dizwell.com
    -A mine of useful Oracle information-
    -Windows Laptop Rac-
    -Oracle Installations on Linux-
    ===========================================


    Howard Guest

  3. #3

    Default Re: Enable 32K Block in 8K Block DB

    [cutting] 

    I'd disagree, the jury is in, all things being equal raw is faster. But
    all things are not equal :-)) so the debate goes on
     

    --
    Paul Watson #
    Oninit Ltd # Growing old is mandatory
    Tel: +44 1436 672201 # Growing up is optional
    Fax: +44 1436 678693 #
    Mob: +44 7818 003457 #
    www.oninit.com #
    Paul Guest

Similar Threads

  1. IP Block
    By Med Marijuana in forum Macromedia Dynamic HTML
    Replies: 7
    Last Post: April 30th, 05:33 PM
  2. Bad Block on 4.5
    By Scott in forum FreeBSD
    Replies: 2
    Last Post: March 28th, 10:29 PM
  3. block specified ip
    By R C P in forum Web Design
    Replies: 1
    Last Post: December 26th, 02:21 PM
  4. Replies: 0
    Last Post: January 8th, 08:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139