Question

6
Replies
914
Views
Hareen.Yadlapalli Member since 2011 17 posts
Incessant Technologies Pvt Ltd.
Posted: February 4, 2016
Last activity: March 30, 2016
Closed

Options to seperate BLOB from work tables

Hi,

Size of our work tables has been increased over a period of time and in case of any database issue, recovery of data in the database might take 1-2 days.

To mitigate this risk, we are thinking about the options on separating the blob column from our work tables.

Below are the options that we are after…

  • Store BLOB data in file system
  • Store BLOB data in a different table separating it from the main tables

Couple of questions around this:

  • Ø Is this possible to separate out blob from our main tables?
  • Ø If so, is this already been implemented at any other customer place?

Regards,

Hareen

Data Integration
Moderation Team has archived post
Share this page LinkedIn