MQSeries.net :: View topic

mpong · Posted: Wed Mar 01, 2017 8:57 am Post subject: BLOB data

Hello All,

I have a requirement where I need to fetch around 1 or 2 MB of data from the database and transform into JSON request and call a rest based web service.

All these 1000 records will have a unique identifier and the status column's on DB, thru which IIB can pick up every batch of records at once.

Is it better to place all these records on a DB as BLOB, so that IIB can fetch once column and parse it based on delimited or have it as a individual record having multiple columns and fetch all rows at once, will it make any difference on IIB. Please suggest