Re: OT: file system versus databases
On 02/23/2009 10:28 PM, Mag Gam wrote:
I was curious why this was faster:
At our company we store close to 50TB of certain transaction data and
we stored it on a UNIX filesystem raw without any DBMS help.
This doesn't sound very Linuxy...
For example:
country/A/name/A.txt
country/B/name/B.txt
country/C/name/C.txt
and so on...
We have close to 500 million entries in this format.
When we do a read() on a file, its very fast and we enjoy it. Would we
get a similar performance if we use a database and index it?
RDBMSs are complex. *Very* complex. And they have to perform a
whole lot of different tasks.
Simple sequential reads thru a text file, though, should always be
faster than a similar DB tablespace because of, if nothing else, the
host's cache.
--
Ron Johnson, Jr.
Jefferson LA USA
The feeling of disgust at seeing a human female in a Relationship
with a chimp male is Homininphobia, and you should be ashamed of
yourself.
Reply to: