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

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
Can't really add a huge amount to David's post above, but from experience, the impact on DB maintenance tasks is a big one to consider. I worked with a 500GB database, where 300GB was BLOBs of invoices (PDFs mostly). Backups, restores, disaster recovery, dump and load activities, all took a huge amount of time more than they should have done. If you do go with Blobs, do make sure you keep them in a separate storage area.

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