| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| handling large message contains MIMEs (such as images) |
« View previous topic :: View next topic » |
| Author |
Message
|
| Vitor |
 Posted: Thu May 14, 2015 4:34 am Post subject: |
 |
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Vitor wrote: |
| RaviSavi wrote: |
| In which format the MIME message is stored in database. |
However you chose to store it. A MIME (Multipart Internet Mail Extension) message holds any kind of data as separate "sections" in a message. So you'd hold a MIME section that contained an XML document differently to one that contained a JPG image. |
Or not. |
Or not. That probably wasn't the clearest contrast I could have chosen. But you get where I'm going.
For more  . That's where I'm going.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
 |
| RaviSavi |
| Posted: Thu May 14, 2015 6:05 am Post subject: |
|
|
Novice
Joined: 20 Apr 2015
Posts: 14
|
Hi
Thanks for posts.
We dont have DBAs right now.we are in startup project.
I myself created tables etc.,
I could be able to insert into database a part of MIME msg casted as BLOB.
Right now thinking off pushing Whole OutputRoot.MIME.Parts........
in to Db |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 14, 2015 6:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| RaviSavi wrote: |
We dont have DBAs right now.we are in startup project.
I myself created tables etc., |
Then you should either find a DBA or consult a developer with more database experience.
| RaviSavi wrote: |
| I could be able to insert into database a part of MIME msg casted as BLOB. |
You could. Especially if you've determined it's an image. How would you key and index it in the database
| RaviSavi wrote: |
Right now thinking off pushing Whole OutputRoot.MIME.Parts........
in to Db |
Are you sure you mean "thinking"? How do you intend to reserialise the message tree for insert, even if you plan to store it as a BLOB? How do you plan to retrieve and process this BLOB from the database, especially if this retrieval process isn't being done by broker (hint - the BLOB in the database will be some representation of the broker's message tree, an unpublished IBM proprietory format)?
If your project is a start up, then you seem to have moved too quickly through the design phase into the coding phase. Certainly it's hugely unwise to be architecting and coding a database solution without any DBA input.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
