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 -> Filesystem a factor in DB transaction speed ?

Filesystem a factor in DB transaction speed ?

From: vrw <linux4me2000_at_netscape.net>
Date: Sat, 1 Dec 2001 22:22:09 +0000
Message-ID: <9ubl2m$3a5$1@news7.svr.pol.co.uk>


Hello all,
I am currently reading D.E.Knuth, Art of Computer Programming, Volume 3, Sorting and Searching. Whilst reading up on searching, it occured to me that the performance of Oracle could be tremendously impacted by the type of filesystem used by the underyling operating system. I personally use SuSE Linux, and have used the balanced-tree-based Reiser filesystem for years. Its method of storing data on the harddrive is very, very similar to that of a database, in that it uses key/value pairs, and builds a hash code to locate items. Because it is balanced, locating items happens extremely quickly.
Comparing item location speed of Reiser FS with some of the Windoze-based block-aligned junk (FAT, NTFS), I think this could be quite an issue for DBAs aiming to increase database speed (especially retrieving info). Has anybody done any comparisons (such running Oracle in an identical kind of setup on both M$ and Linux systems) or does anyone have just some general observations ?
This might be an interesting subject to dive into.

Any feedback is appreciated.

Regards,

Volkmar Received on Sat Dec 01 2001 - 16:22:09 CST

Original text of this message

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