Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

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,

"We are not alone"(FZ)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://93542]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2018-01-23 08:26 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (241 votes). Check out past polls.