Question
6
Replies
932
Views
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
Hi Hareen,
It is not a best practice to remove the blob from the work tables.
Probably, you can check with the size of the work page of each work objects. If it is too high, then you can optimize the size of the work page.
Some customers may flush or backup the older work objects data in equal interval of time to reduce the DB load. Check if it can be applicable for you.
Thanks.