Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Mysql, CSV, and flatfiles, a benchmark.

by TheoPetersen (Priest)
on May 07, 2001 at 19:35 UTC ( [id://78536]=note: print w/replies, xml ) Need Help??


in reply to Mysql, CSV, and flatfiles, a benchmark.

At last someone has done a comprehensive analysis of apples and oranges :) While I won't disagree with your results, I suggest these paragraphs should be included:

MySQL is not a flat file, it is a relational database. It is good at things that relational databases do well, such as retrieving related rows from multiple tables at once.

Flat files are not relational databases. They are good at things such as writing data sequentially to the end of a table or retrieving data with ad-hoc structure.

Don't use flat files when you need a relational database; you'll spend endless time implementing things that you can have for free by using the right data manager. Similarly, avoid making your relational database stand in for a simple flat file unless you will need relational capabilities on the data stored in the file later.

  • Comment on Re: Mysql, CSV, and flatfiles, a benchmark.

Replies are listed 'Best First'.
Re: Re: Mysql, CSV, and flatfiles, a benchmark.
by illitrit (Friar) on May 07, 2001 at 19:59 UTC
    Thank you for saying what I wanted to say but couldn't form into a coherent bit of text.

    Alot of users do NOT realize the truth of what you say, myself included when I first discovered Mysql and other relational databases. Without your addendum I fear my post may have helped confuse such people more than it helped.

    Thanks, James
Mysql != RDBMS
by grinder (Bishop) on May 09, 2001 at 13:24 UTC

    MySQL doesn't do subqueries, nor does it implement commit/rollback (and a host of other features, but I sure would miss these two were I required to use it).

    It's great if you consider it as flatfiles-on-steroids, which is what the gist of this benchmark seems to be about. On the other hand, if you're looking at MySQL as an Oracle-on-the cheap, then there's a good article on why that is a Bad Idea.

    PosgreSQL forever!


    --
    g r i n d e r

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://78536]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2024-04-19 21:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found