[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Save files in database: good or bad?

  • Thread starter Thread starter Jeff Ledbetter
  • Start date Start date
Status
Not open for further replies.
J

Jeff Ledbetter

Guest
We save binary files in an OpenEdge database, but we do not use BLOBs. We store as RAW chunks (1 record per chunk) in a table that it is in a dedicate area. We were doing it this before BLOBs came about and it's proven to be simple and reliable. We also save on disk as well via a configured "depot" that our application reads/writes to/from. We maintain a "pointer" record in the database so it can find its counterpart on disk. It's faster than above but there is the extra overhead of backing up but once it's in place it's no big deal. If speed is not an issue, I would store as RAW chunks.

Continue reading...
 
Status
Not open for further replies.
Back
Top