473,326 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

blobs in table

Ike
I have blob fields in some tables - never more than one field in any table,
and never where a blob can be > 64k. I have inherited the code for this
project from someone else, and was considering investing considerable effort
in this case to move the blobs over to a separate table altogether.

I am wondering if it is worth it however. Is it disasterous to have a single
blob field (which frequently is merely null) in a table. I have three tables
that can have a single blob in them. Am I decieving myself thinking I can
allow this to be the architecture? Please give me your advice, Ike
Jul 20 '05 #1
2 1870
Ike wrote:
I have blob fields in some tables - never more than one field in any table,
and never where a blob can be > 64k. I have inherited the code for this
project from someone else, and was considering investing considerable effort
in this case to move the blobs over to a separate table altogether.

I am wondering if it is worth it however. Is it disasterous to have a single
blob field (which frequently is merely null) in a table. I have three tables
that can have a single blob in them. Am I decieving myself thinking I can
allow this to be the architecture? Please give me your advice, Ike


I'm also looking for how to do this.

MP.
Jul 20 '05 #2
I have found that including BLOB fields in a table that also contains CHAR
fields, the CHAR fields will be forced into VARCHAR fields. What I do is put
BLOBs into thier own table with a link identifier like so:

Table_1
id(bigint), blob_size(medint), blob_id(bigint)

Table_2
blob_id(bigint), blob_data(medblob)

and:

SELECT blob_size, blob_data FROM Table_1, Table_2 WHERE Table_1.id = ?? AND
Table_2.blob_id = Table_1.blob_id LIMIT 1

should give you the blob_size and blob_data where the blob_id's match...
Norman
--
Avatar hosting at www.easyavatar.com
"Mathieu Pagé" <ma**************@GoogleEmailSystem.com> wrote in message
news:OV********************@wagner.videotron.net.. .
Ike wrote:
I have blob fields in some tables - never more than one field in any table, and never where a blob can be > 64k. I have inherited the code for this
project from someone else, and was considering investing considerable effort in this case to move the blobs over to a separate table altogether.

I am wondering if it is worth it however. Is it disasterous to have a single blob field (which frequently is merely null) in a table. I have three tables that can have a single blob in them. Am I decieving myself thinking I can allow this to be the architecture? Please give me your advice, Ike


I'm also looking for how to do this.

MP.

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Kirby Urner | last post by:
I've been testing the Cookbook example 8.6 (2002 edition) re using cPickle to insert and retrieve BLOBs from mySQL, using Python's MySQLdb module. When I try to cPickle.loads(blob), I get an...
0
by: Ole Hansen | last post by:
Hi, I have a working application inserting rows to a table using the array interface. Now I want to insert BLOBs as well but OCIStmtExecute crashes when executed with BLOBs. For BLOB types I...
1
by: Jesse Wolgamott | last post by:
I've seen plenty of posts regarding the estimation of table size, usually in the processing of planning for server storage needs. Well, I've got a different problem. I need to know how much data...
7
by: Howard Lowndes | last post by:
My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2 I have no difficulty inserting and managing BLOBs into the Large Object system table, and I have a user table called images...
0
by: omkar prabhu | last post by:
i am using postgres 7.0.3 and also postgres 7.2.1 I am new towards using blobs,I want to transfers records with blobs from a table to different database(postgres) using perl without extracting...
0
by: .Net Newbie | last post by:
I am currently working with the C# version of the PortalSDK in a text editor and have run across a bug that I need to resolve in order for my app to function properly. Basically, I'm using the...
2
by: Jerry LeVan | last post by:
Hi, I am just getting into large objects and bytea "stuff". I created a small db called pictures and loaded some large objects and then tried to do a restore. Here is how I got the dump. ...
2
by: Connie | last post by:
We have a blob in one table that is storing pdf files. I need to write a select query that will grab that column and write those *.pdf files out to a location on my hard drive. Does anyone know...
5
by: bhodgins | last post by:
Hi, I am new on here, and had a newbie question that I am stumped with. I am not new to access, but am new to VB. I am trying to export BLOBs from a field called photo to external jpeg files. I...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.