Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
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)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://93542]
help
Chatterbox?
[Discipulus]: hi zentara!
LanX gets eaten by a black hole popping up in the vacuum of his head

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2017-06-23 16:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (552 votes). Check out past polls.