Binary Large OBject, datatype

learn more… | top users | synonyms

1
vote
1answer
43 views

How to export a MySQLtable with a longBLOB column to an Oracle database?

In MySQL I have a table: Select * from Dummy; Columns like below: id name salary binary_col 1 a 100 A.pdf 2 b 200 b.pdf 3 c 300 c.pdf 4 d 400 d.pdf 5 e 500 e.pdf ...
0
votes
1answer
42 views

Does having a big table that I do not query cause the whole DB to be slower?

I have a log table that I use for logging files sent to clients. I'm not querying that table, just use it for logging (INSERT) and when I need to check when something was sent to clients, usually once ...
2
votes
0answers
156 views

Empty Space in buffer pool

I was doing some reading and came across this article from Paul Randal: http://www.sqlskills.com/blogs/paul/performance-issues-from-wasted-buffer-pool-memory/ Using the queries from that article, I ...
1
vote
0answers
401 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; ...
0
votes
0answers
21 views

How to select full text in the blob type?

There's some large text segments stored in database table BLOB column, and when I query that column against database , usually only part of that large texts get displayed. I am not sure whether this ...
0
votes
0answers
108 views

Get data from BLOB (BINARY) type field

I got a Firebird database which I need to convert to a SQLite one. I've connected just fine and was able to export VARCHAR, INTEGER, etc. data with a few lines of C# However there's this column ...
0
votes
0answers
198 views

Storing files in Mongo's GridFS vs File System

I read the question here: http://programmers.stackexchange.com/questions/150669/is-it-a-bad-practice-to-store-large-files-10-mb-in-a-database and this paper: ...
0
votes
0answers
28 views

Reliability of blobs in MySQL

I'm in the process of migrating an application working with Oracle to MySQL. That application stores data in the form of blobs, which can be pretty big. The Oracle production database is 60 Gb large ...