Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Filesystem a factor in DB transaction speed ?
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
![]() |
![]() |