storing and reading blob
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
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.