Storing Documents as Blobs in a Database – Any disadvantages?

by

When your DB grows bigger and bigger it will become harder to backup.
Restoring a backup of a table with over 100 GB of data is not something that makes you happy.

Another thing that get is that all the table management functions get slower and slower as the dataset grows.
But this can be overcome by making your data table just contain 2 fields:
ID and BLOB.

Retrieving data (by primary key) will likely only become a problem long after you hit a wall with backing up the dataset.

More Related Contents:

  1. Performance optimization strategies of last resort [closed]
  2. How to find the kth largest element in an unsorted array of length n in O(n)?
  3. HTTP vs HTTPS performance
  4. Is performance reduced when executing loops whose uop count is not a multiple of processor width?
  5. Why are loops slow in R?
  6. Is it safe to shallow clone with –depth 1, create commits, and pull updates again?
  7. Is recursion ever faster than looping?
  8. How are x86 uops scheduled, exactly?
  9. Why is my Rust program slower than the equivalent Java program?
  10. How can I accurately benchmark unaligned access speed on x86_64?
  11. How much overhead does SSL impose?
  12. When, if ever, is loop unrolling still useful?
  13. Is ADD 1 really faster than INC ? x86 [duplicate]
  14. Clear file cache to repeat performance testing
  15. MATLAB parfor is slower than for — what is wrong?
  16. What’s the (hidden) cost of Scala’s lazy val?
  17. Given n points on a 2D plane, find the maximum number of points that lie on the same straight line
  18. Why is a conditional move not vulnerable to Branch Prediction Failure?
  19. Run-length decoding in MATLAB
  20. Android studio takes too much memory
  21. Most efficient list to data.frame method?
  22. x86_64: is IMUL faster than 2x SHL + 2x ADD?
  23. Has anyone actually implemented a Fibonacci-Heap efficiently?
  24. Number of partitions in RDD and performance in Spark
  25. SUMIFS function in Google Spreadsheet
  26. Optimizing File Cacheing and HTTP2
  27. latency vs throughput in intel intrinsics
  28. Performance of using static methods vs instantiating the class containing the methods
  29. Safe alternatives to PHP Globals (Good Coding Practices)
  30. Why does the Execution Plan include a user-defined function call for a computed column that is persisted?

Leave a Comment