Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: mySQL or Flat Files, Which is faster

by CountZero (Bishop)
on Feb 08, 2004 at 15:07 UTC ( [id://327463]=note: print w/replies, xml ) Need Help??


in reply to mySQL or Flat Files, Which is faster

Speed is of course a major thing to consider, but equally (if not more) important is the matter of concurrent access to your data-files.

Flat files not living within a database server allow multiple readers but cannot allow multiple concurrent writers.

Database servers (such as MySQL or PostgreSQL) allow such multiple read and write access.

If you take that into account, there is no choice: only a real database server will do.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

  • Comment on Re: mySQL or Flat Files, Which is faster

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (2)
As of 2024-04-26 03:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found