Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: When is a flat file DB not enough?

by jeroenes (Priest)
on Jul 03, 2001 at 19:28 UTC ( #93542=note: print w/ replies, xml ) Need Help??


in reply to When is a flat file DB not enough?

Well, it depends on a lot of parameters. A short answer is: use bogus data to test your setup. Test it to its limits, and find out where you can expect problems.

What kind of limits can you think of?

  1. Size limits. Maybe 'more' hardware can help out. Maybe you can compress the data with gzlib or the like.
  2. Speed limits. Maybe 'more' hardware as well. Maybe a migration to another DB system might help (BerkeleyDB did wonders for me).
  3. Usability limits. Think about multiple users accessing at the same time. BerkeleyDB or file locking scemes can help.

RDMBS like oracle/mysql have the tendency to solve problems at all three levels.....

Hope this helps,

Jeroen
"We are not alone"(FZ)


Comment on Re: When is a flat file DB not enough?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (16)
As of 2014-07-14 15:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (268 votes), past polls