Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Storing files in a database

by blue_cowdawg (Monsignor)
on Aug 11, 2003 at 01:39 UTC ( [id://282717]=note: print w/replies, xml ) Need Help??


in reply to Storing files in a database

      However, If this approach has more drabacks than benefits, I'll just revert to using a sql table to manage on-disk files.

This is exactly what I would suggest. Take it from my personal experience with this one. I once tried setting up a database table with all my graphics for my website stored as BLOBs. Loading the pages became very inefficient while waiting for the bits to be dragged into memory and then spit out.

Using the database as an index to on disk files is a much better way to go IMHO.


Peter @ Berghold . Net

Sieze the cow! Bite the day!

Nobody expects the Perl inquisition!

Test the code? We don't need to test no stinkin' code!
All code posted here is as is where is unless otherwise stated.

Brewer of Belgian style Ales

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2024-04-19 19:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found