The blob tag has no wiki summary.
34
votes
9answers
3k views
Files - in the database or not?
What is the best place for storing binary files that are related to data in your database? Should you:
Store in the database with a blob
Store on the filesystem with a link in the database
Store in ...
4
votes
1answer
59 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
919 views
Export table without BLOB column
I have a big table with BLOB objects and some references from other tables to this one.
I prepare dev and test schema for my app by making expdp (data pump) from production, then anonymizing data on ...
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 ...
2
votes
1answer
183 views
Data type for protobuf objects in mysql
I would like to store some protobuf objects in a MySQL database. The objects are created in a Java application. The object is accompanied with a textual type identifier and a timestamp.
...
2
votes
1answer
91 views
Selecting with varbinary(max) criteria (in the where clause)
Basic info
Database: SQL Server Express 2008 R2
Client: SQL Server Management Studio
Backround (skip if not interested):
A project I'm maintaining uses an ORM, which apparently stored my enum ...
2
votes
1answer
383 views
How to copy bytea from Postgres to Oracle
I have a db on Postgres 9.1. The db collected some binary data that are stored in bytea file.
I need to copy the data to Oracle 10g. How to do it?
The details
I have a table plines in Postgres9.1. ...
1
vote
1answer
163 views
Which Database to choose: MySQL or Oracle
I have an application generating time series data (32 channels, 22KHz, 6 secs) once a minute. These have to be stored in a database. At the moment I'm using MySQL with InnoDB tables ...
1
vote
1answer
83 views
import csv data stored in a blob column
Here's what i need to do:
Users will upload CSV files into SQL Server 2012 blob column
Each night, i would like to take each file and import the data into table
I will have 2 web sites using the ...
1
vote
1answer
135 views
Possible reasons for slow BLOB updates in Oracle?
We have an application that transfers .bmp images as BLOBs to an Oracle table. One of the users of the app has complained that it is taking 2-3 seconds to transfer each image. Each image is ~1.2Mb. ...
1
vote
1answer
397 views
Java application unable to access Blob stream in Oracle after upgrade to 11g
This issue below might be an application problem, but I cannot seem to rule out a poor database setup, I was hoping to get some insights into potential database issues.
I am maintaining a legacy Java ...
1
vote
1answer
169 views
What is the underlying representation of BLOB data when I export it?
When I export a blob object to an SQL file, I get some thing like this for a blob field:
0x4f3a383a227374644.....,
Questions
I would like to know how the BLOB is actually converted to the above ...
1
vote
0answers
238 views
How can one reliably update a LOB column with data from another LOB column in Oracle?
I have tried:
UPDATE "SCHEMA".TABLE SET LOB_COLUMN = (SELECT LOB_COLUMN FROM "SCHEMA".TABLE)
I have tried:
CREATE OR REPLACE PROCEDURE COPY_LOB_DATA IS
OLD_BLOB BLOB;
NEW_BLOB BLOB;
...
1
vote
0answers
231 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 ...
0
votes
1answer
144 views
Length of LOB data (%1) to be replicated exceeds configured maximum %2
We recently hit this error shortly after enabling replication on a table.
Length of LOB data (%1) to be replicated exceeds configured maximum %2
I've found solutions to this problem already:
...
0
votes
0answers
65 views
Copying BLOB fields from a table on one server into corresponding fields in a corresponding table on a different server?
I have a database on a remote server whose BLOB fields are corrupted. I have fields in an earlier copy of the database which duplicate a portion of the corrupted data. I would like to overwrite the ...
