Hi,
I store file in db in blob but overtime become 30GB. even though i restrict file size less than 1mb.

the db become slow that simple "select * from img" very slow.

i thinking simplest change is export all blob out using INTO DUMPFILE and read it using LOAD_FILE .

my question . is this good solution ? or worse than store in db .

Subject

Written By

Posted

storing and reading blob

May 28, 2026 05:21AM