database vs filesystem performance

[Francois Ouellette]

----- Original Message ----- 
From: "Marc Lijour" <marc-bbkyySd1vPWsTnJN9+BGXg at public.gmane.org>
To: <tlug-lxSQFCZeNF4 at public.gmane.org>
Sent: Sunday, 07 August, 2005 21:34
Subject: Re: [TLUG]: database vs filesystem performance


On August 7, 2005 21:27, Francois Ouellette wrote:
> ----- Original Message -----
> From: "Marc Lijour" <marc-bbkyySd1vPWsTnJN9+BGXg at public.gmane.org>
> To: <tlug-lxSQFCZeNF4 at public.gmane.org>
> Sent: Sunday, 07 August, 2005 21:04
> Subject: Re: [TLUG]: database vs filesystem performance
>
> On August 7, 2005 20:52, Francois Ouellette wrote:
> > ----- Original Message -----
> > From: "Marc Lijour" <marc-bbkyySd1vPWsTnJN9+BGXg at public.gmane.org>
> > To: <tlug-lxSQFCZeNF4 at public.gmane.org>
> > Sent: Sunday, August 07, 2005 7:50 PM
> > Subject: [TLUG]: database vs filesystem performance
> >
> > > Does somebody know the compared performance of the filesystem against
a
> > RDBMS?
> >
> <snip>
>
> You may be able to read 3000+ records per second from a RDBMS once the
data
> has been read and put into its server cache.
> However, as you say, RDBMS are not very good at storing binary data apart
> from the usual integer and float formats.
> BLOBS are a possibility but some RDBMS store them as single flat files
too!
> Unless you really have to use a RDBMS because of some requirement of the
> application my suggestion would be to stick to flat files.
>
> My experience with journaled file systems available on most UNIX platforms
> and also Linux (reiserfs and ext3) systems has so far been positive, the
> best I had to work with was the Advanced File System of the declining
Tru64
> system, originally developed for DEC-OSF.
>==========================================================
>
> Do you know how it does compare with MS NTFS?

There may not be data integrity problems with NTFS, but the Windoze system
using it might be a bigger problem!

Sorry, this may be a biased opinion but I have seen so many performance
problems with Windoze SQL Servers systems, even MS have difficulties in
helping how to tune the software to make it perform acceptably, even on
monster Wintel machines with huge memory.
The same hardware with Linux and an open source RDBMS worked immensely
better...

  François Ouellette
<fouellet-cpI+UMyWUv9BDgjK7y7TUQ at public.gmane.org>






--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml