Re: Performance question: single datafile vs multiple datafiles

From: Yong Huang <yong321_at_yahoo.com>
Date: 28 Feb 2002 09:42:17 -0800
Message-ID: <b3cb12d6.0202280942.5acc0ecb@posting.google.com>

If there's only one physical disk, the difference is very small. Suppose the file is opened and closed very frequently, further suppose it's written a lot (not mostly for read), splitting into multiple files helps to reduce inode locks.

Yong Huang
yong321_at_yahoo.com

dub_at_latnet.lv (Dub) wrote in message news:<6445524b.0202280750.cd1f633_at_posting.google.com>...
> Hi,
>
> What is better from performance point of view - to extend existing
> single datafile or to add one more datafile?
>
> Assume I use the same physical disk.
>
> Any suggestions/links will be highly appreciated.
>
> BR,
> Dub
Received on Thu Feb 28 2002 - 11:42:17 CST