Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What blocksize?

What blocksize?

From: kev <kevin.porter_at_fast.no>
Date: Tue, 17 Aug 1999 10:57:04 +0100
Message-ID: <37B931F0.FF36758A@fast.no>


Hi,

I'm wondering what blocksize to use for a DB I'm creating. In the O'Reilly book they suggest:

"- Choose a small blocksize (2048 or 4096) for transaction systems where there are frequent queries, inserts, and updates that involve a single row.
- Choose large blocksize (8192 or larger) for data warehouses and other
large DB application where most data is bulk loaded, there are few updates, and most queries return multiple rows or involve full table scans"

I building a database driven website on Red Hat Linux 6, so neither of the above scenarios really fits my situation. The second one probably comes closer, so I'm thinking at the moment that 8192 would be preferable. I'd be interested to know what blocksize others have used for similar applications on the same platform.

TIA

Received on Tue Aug 17 1999 - 04:57:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US