Questions tagged [blob]

Binary Large OBject, datatype

Filter by
Sorted by
Tagged with
1
vote
0answers
21 views

Oracle 12.2 shows high execution/parse cound for lob$ query

In an AWR report I see the following (most liekly recursive) query which happens very often and is parsed each time: select obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1 The ...
0
votes
1answer
90 views

ORA-12516: when accessing another database via link

I need to bring some data (blobs) from another database. I created global links to enable bidirectional communication. The links work. When I try to bring some data from tables that have BLOB columns ...
1
vote
0answers
51 views

SQL Server Transaction Log Full affect on FileStream [closed]

These are general question I would like to receive some inputs from experts with BLOB SQL Data. How will SQL Server Transaction Log (.ldf file) linked to SQL Server FileStream Is it different from ...
1
vote
1answer
376 views

How to insert very big XML data file to PostgreSQL

I'm using PostgreSQL 9.5 and trying to import XML data file to database. To load the XML I use this function from here CREATE OR REPLACE FUNCTION bytea_import(p_path text, p_result out bytea) as $$ ...
-1
votes
1answer
52 views

MySQL - Optimize a table which has mostly text data type

I recently faced some performance issue on a CMS based application. I can somehow fix other tables. But Im not able to optimize the table which has 40+ columns and 10 columns are having text as the ...
1
vote
2answers
47 views

Insert a large TEXT. Is INSERT the only way?

I am not a strong expert in databases at this level, so I was wondering the following. A database I am currently working on has a large TEXT field where potentially hundreds of megabytes are stored ...
0
votes
1answer
113 views

Oracle SecureFiles LOBs Licencing

We argued in our DBA team on whether an Oracle Database with SecureFiles LOBs needs to be an Enterprise Edition. Can I use Oracle Secure File Lobs in a Standard Edition?
1
vote
2answers
37 views

Can you get a filehandle to an Oracle SecureFile LOB?

Does Oracle's SecureFile LOB allow me to obtain a filehandle to the underlying resource. Both PostgreSQL through lo_open and SQL Server with FILESTREAM's OpenSqlFilestream allow you to get a native ...
0
votes
2answers
94 views

Oracle Database LOB increases untypical

An Oracle 12c production database includes tables with a BLOB column. Usually the growth rate is 2GB per week. This is the table create statement: CREATE TABLE XXX.FILEENTRY ( FILENAME VARCHAR2(...
0
votes
1answer
599 views

Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?

I have a problem with opening Large Object in postgresql version 9.2, select * from pg_largeobject where loid = '19423'; will return data like this: loid oid;page no integer;data bytea 19423;0;"<...
0
votes
2answers
282 views

BLOB or VARBINARY to store simple Strings that are converted into byte[ ]?

I've read that In MySQL, BLOBs are often used to store image files, file path pointers, video & audio files, and any other big data objects. But can BLOBs be used for simple Strings that are ...
1
vote
1answer
153 views

Storing files with extension in database as BLOB

Recently during development process I've faced file storage issue. I'm not sure which solution is the best one that's why I decided to write this question. I don't have a lot experience of database ...
3
votes
1answer
176 views

How large is SQLites minimum data storage overhead and what generates them?

Motivation: In my company there exists the (probably strange) idea to store pure time series data in a normal SQL table (instead of using BLOBs or just binary files which would probably be a better ...
1
vote
1answer
47 views

What data is duplicated when MySQL/MariaDB BLOB columns are copied?

Let table_1 be created as follows: CREATE TABLE table_1 ( id INT AUTO_INCREMENT PRIMARY KEY, some_blob BLOB ); Let table_2 be created as follows: CREATE TABLE table_2 ( id INT ...
5
votes
2answers
1k views

Please enlighten me about FILESTREAM and BLOB files

This is a really confusing topic for me. I can understand what a BLOB is, I can easily use it. I can understand what FILESTREAM is. I can easily implement in on a database, I can backup the database ...
4
votes
2answers
1k views

In what cases are BLOB and TEXT stored in-line on InnoDB?

I've googled this and can't find it, you can see Rick James mention it here. ... BLOB and TEXT are not always stored separately The answer on What is the difference between MySQL VARCHAR and TEXT ...
1
vote
1answer
209 views

SQL Anywhere Long Varchar/Binary Column Length Limited to 32767

Attempting to set up a database table (Sybase SQL Anywhere 11.0.1) to store user uploaded documents as either BLOBs or base64 encoded strings, but running into an issue where the length of my LONG ...
0
votes
2answers
94 views

Retrieve date column default values from BINARYDEFVAL column in sys.ecol$

I am trying to retrieve BLOB values in BINARYDEFVAL column from sys.col$ table. The BINARYDEFVAL of sys.ecol$ table stores default column values in BLOB format. For VARCHAR2 and NUMBER I am able to ...
1
vote
1answer
68 views

LOB in frequently queried table or separate table

I have a table named FinTrans in an Microsoft SQL Server 2012 server with approx 10K-30K records at any given time and about 2K records are inserted and deleted each day. The table has 3 nvarchar(...
3
votes
3answers
799 views

How to retrieve a large text from inside a table?

for my own records I have a table in one of my servers where I like to save my activities and scripts the table definition is: IF OBJECT_ID('[dbo].[activity]') IS NOT NULL DROP TABLE [dbo].[...
1
vote
1answer
971 views

Is It Possible to Encrypt varbinary(max) Column Using Always Encrypted Feature?

We want to implement the Always Encrypted feature for our application database. There is a table with a varbinary(max) column which is storing binary data of images, pdf documents, etc. Does the ...
0
votes
1answer
923 views

Oracle reorganize lob segement

On an Oracle 12c database I want to reorganize a LOB segment. I used to following sql to generate the alter move command: select 'ALTER TABLE '||s.owner||'.'||l.table_name||' move to('||l....
0
votes
0answers
33 views

How can I save a file into a longblob column on a database located on another server?

I have a database table that contains large files in one of the columns, stored as longblob data. The blobs can currently be up to around 300MB in size. When reading the blobs from the database I'm ...
1
vote
3answers
1k views

Why to put unstructured data in NoSQL DBs?

The statement that NoSQL databases are better for unstructured data because of their schemaless nature can be found everywhere. Frankly, I don't understand that. A human voice recording is often be ...
1
vote
1answer
370 views

Chunking data into a PostgreSQL bytea column?

I have column of type bytea in PostgreSQL database. If I update a row, is it possible to chunk the data into the bytea column in several small steps? The size of one bytea entry will be mostly below ...
0
votes
1answer
142 views

Export a very big amount of files from a table

I'm using Oracle Database 11g Release 11.1.0.6.0 and have a table recording a very big amount of files (GIF) with IDs (ID). Name Type ------------------------...
0
votes
2answers
655 views

Dump single rows (with blobs) to single files

I am creating MySQLDumps for the sake of versioning of a database. The problem currently is a table with blobs. My first approach would be to dump single tables to single files. But next, I want on ...
0
votes
1answer
540 views

Calculating the FileStream Data Columns Length matching used FS Drive used space

Kindly advice me on below : I am process of calculating the total size of LOB objects with below data types (includes Views and user schema tables) . select * from information_schema.columns where ...
1
vote
1answer
313 views

What is the 131072 in the call to lo_open()

ByteA to BLOB conversions typically make a call to lo_open(), CREATE OR REPLACE FUNCTION make_lo(bytea) RETURNS oid AS $$ DECLARE loid oid; fd integer; bytes integer; BEGIN loid := lo_creat(-...
5
votes
0answers
1k views

VARCHAR(MAX) taking more space than NVARCHAR(MAX) [duplicate]

I have a table in SQL Server 2012 Enterprise Edition that has ~100GB of data. Most of this data is attributed to a single NVARCHAR(MAX) column which has an average length of 4500 characters. It stores ...
2
votes
2answers
3k views

Writing Oracle BLOB field to raw file in a Cursor or For loop result empty file

I am stuck at this for a while and had been Googling for answer but can't seem to find any.... I have an Oracle 9i table with BLOB field that I need to extract the BLOB field into a raw file on the ...
1
vote
0answers
38 views

Wasted space for compressed SecureFile LOBs?

When using Oracle BasicFile and SecureFile one property of the implementation is that each LOB occupies multiples of the chunk size (and in case of SecureFile the smallest chunk size is the block size)...
8
votes
1answer
582 views

Best way to shrink a DB after nulling data from varbinary(max)?

We have a database with a large amount of data stored in a field of type varbinary(max). At some point we can purge that data for most rows, but not all. Our plan is to make that field nullable, and ...
5
votes
1answer
8k views

How to copy blob (binary data) from one DB to DB using a script?

We are trying to copy a blob (binary data) from one Database to another Database using a simple script. This is the steps we do. Select the value using MSSQL Studio Client. Copy it into the clipboard....
2
votes
1answer
142 views

Does AWS ever `vacuumlo` PostgreSQL RDS instances?

Link to the long story happened before (and reason to have) this question. Does AWS ever vacuumlo PostgreSQL RDS instances?
27
votes
3answers
10k views

Why is it recommended to store BLOBs in separate SQL Server tables?

This highly-upvoted SO answer recommends to put images in separate tables, even if there is only a 1:1 relationship with another table: If you decide to put your pictures into a SQL Server table, I ...
3
votes
2answers
2k views

How to `vacuumlo` an RDS PostgreSQL database?

As you may have noticed, as a fully managed data base as a service product, AWS Relational Data base Service (RDS) restricts the execution of userland commands. I was staging a production database, ...
3
votes
2answers
10k views

How to show Large Objects (LOB) contents? [duplicate]

How could I get to have a look into LOB contents? \d ticketgrantingticket Table "public.ticketgrantingticket" Column | Type | Modifiers ----------...
1
vote
0answers
177 views

Clean up space used by internal LOB in Oracle

I have a table with a CLOB column which is stored as internal LOB. The data in this column becomes obsolete quickly (within matter of days), and is never accessed afterwards. I wonder whether ...
2
votes
1answer
1k views

Storing large files (~1GB) in MySQL

We are considering a solution that will store large files in MySQL with InnoDB. The size of the files can range from 250MB - 1GB (might grow up to 50GB in future). Here is what the plan is. Create ...
2
votes
2answers
6k views

How to insert big blob data in Oracle?

I'm trying the following: INSERT INTO (blob_column) VALUES (HEXTORAW('very big hex here')) But I'm getting the following error: ORA-01704: string literal too long How can I workaround that? Is ...
3
votes
1answer
567 views

Database for store images

Actualy I'm using MongoDB with embedded images next to other data in same documents. Images count actualy are more than 14000 and each image size is less than 1MB. Images are readed frequently and ...
0
votes
1answer
339 views

Does dbms_lob.getlength return the compressed or uncompressed length?

If you have tablespace compression turned on, does dbms_lob.getlength return the compressed or uncompressed length of lobs stored on that tablespace? What about LOB compression?
1
vote
1answer
269 views

What Backup Compression Rate Can I Expect for a Database with Mostly JPG Data?

I am considering using a database to store one or more images (.JPG) associated with a record identifier and filename. CREATE TABLE Images ( RecordID BIGINT NOT NULL, ImageFilename VARCHAR(50)...
3
votes
1answer
1k views

Very slow query on table with Blob column [closed]

I have a table with approximately 3500 rows. This table contains a longblob column with an average blob size of 750kb. My query performance really deteriorates when trying to filter on the primary ...
0
votes
1answer
69 views

Re-page Oracle tables after removing CLOB fields

I have a table that has a large amount of CLOB data and a large number of records. Even with indexes, some queries are extremely slow. My assumption is that the reason for this is two fold: There's a ...
1
vote
0answers
86 views

Most Efficient way to compare large 'text' type values in MySQL using InnoDB

I have a staging table like this : CREATE TABLE `staging` ( `created_here_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `desc_text` TEXT NOT NULL ); And destination table as : CREATE ...
1
vote
1answer
751 views

Do large longtext necessarily slow down a database

I have a MySQL database that is over a million rows, and has a longtext type data column. Most of these are fairly short, but a few dozen of these rows have more than a MB in the longtext column. No ...
1
vote
0answers
224 views

will vacuumlo find orphaned objects

A Table (mytable) is having 2 columns id_ | loid_ (integer) | (oid) Values are id_ | loid_ 1 | 15001 2 | 15002 Value in loid_ column refers the oid from pg_largeobject. And if I ...
0
votes
1answer
2k views

oid vs bytea in postgres

I have a table called tblA and its having two columns id_ (numeric 50,0), obj_ oid For example, tblA having 1 entries id_ | obj_ 1 | 1001 In pg_largeobject table, there are three entries ...