Tagged Questions

4
votes
1answer
62 views

Oracle BLOB store performance

LOBs in Oracle are stored in-row when they are less than 4K in size and out-of-row otherwise. I'm wondering how do SECUREFILE storage options COMPRESS and ENABLE STORAGE IN ROW work? I have a lot of ...
3
votes
1answer
100 views

Can I use mysql to serve 100's of millions of small image files?

I need to serve 300,000,000 small image files totaling 1.5TB. Trying to unpack these files to individual files on the file system is next to impossible (1 MByte/sec throughput rates to create the ...
1
vote
0answers
232 views

DBMS_LOB.READ performance and Oracle BLOB chunk size

I have a script that reads a lot of BLOBs using DBMS_LOB.READ, in the process of converting them to files. While looking to improve the read speed, I looked at GETCHUNKSIZE. The documentation on ...