On Fri, Jun 02, 2000 at 02:26:58PM -0400, [EMAIL PROTECTED] wrote: > > I know about Informix, but I heard Oracle was moving away from raw > > devices, and the speed improvement was only a few percentage points. > > For Informix it's far more than a few percentage points; and then > when you add striping you move even faster. There is nothing stopping you from using striping with filesystems. The overhead of using filesystems are very small, so the only way to get better performance is from doing better caching. In other words, it only makes sence if using raw devices disable the buffer-cache, and the database cache is better than the OS-cache. It will be very different from OS to OS. -- Ragnar Kjørstad
- Re: [ADMIN] Database/table limits ?????... Bruce Momjian
- Re: [ADMIN] Database/table limits ... Ross J. Reedstrom
- [ADMIN] Future plans for raw devic... Norbert Meissner
- [ADMIN] Re: Future plans for raw d... Bruce Momjian
- Re: [ADMIN] Re: Future plans for r... Karel Zak
- Re: [ADMIN] Re: Future plans for r... Bruce Momjian
- Re: [ADMIN] Re: Future plans for r... Karel Zak
- Re: [ADMIN] Re: Future plans for r... Max Pyziur
- Re: [ADMIN] Re: Future plans for r... Bruce Momjian
- Re: [ADMIN] Re: Future plans for r... pyz
- Re: [ADMIN] Database/table limits ... Ragnar Kjørstad
- Re: [ADMIN] Database/table limits ?????... Chris Albertson
- Re: [ADMIN] Database/table limits ... joe briggs
- Re: [ADMIN] Database/table limits ?????? Norbert Meissner
- Re: [ADMIN] Database/table limits ?????? Bruce Momjian