Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Storing files in a database

by TomDLux (Vicar)
on Aug 11, 2003 at 01:06 UTC ( [id://282715]=note: print w/replies, xml ) Need Help??


in reply to Storing files in a database

If you store data but hardly ever read it back, it hardly seems worth storing.

Databases are useful when you need to locate moderate sized data in amongst tons of other stuff. Fetching mega-chunks of data will lead to problems about how much you can fetch in one read.

Why not store the path to the data in the DB, but leave the file in the filesystem. SQL will provide the path to the file that should be read.

--
TTTATCGGTCGTTATATAGATGTTTGCA

Log In?
Username:
Password:

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

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

    No recent polls found