Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: When is a flat file DB not enough?

by jeroenes (Priest)
on Jul 03, 2001 at 19:28 UTC ( [id://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)

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://93542]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others studying the Monastery: (3)
As of 2024-04-26 06:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found