Skip to Content

Store big size tables with BLOB on disk instead of in memory in SAP HANA

Dear all,

is it possible to avoid loading of some big sized tables with BLOB data to memory in SAP HANA for ABAP based application? E.g. a big amount of images / scanned documents (>1T) as attachments to trancactional data and just access these attachmens on demand (line-by-line).

I've found some information where similar approach seems to be used: co-innovation project with Springer Science+Business Media (~3.8 Million rows (296 GB in memory / 4 TB on disk).

Thanks in advance for your response.

Alexander

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 14, 2014 at 03:22 PM

    Hello Alexander,

    LOBS are handled separately during access.

    As of SPS 7 you can decide whether a LOB should be stored within the tables storage containers or whether each lob should have its own storage container that can independently loaded to memory upon request.

    In fact you can set a threshold keeping smaller LOBs in a shared container and have the extra handling only active for larger ones.

    See ALTER TABLE - SQL Reference - SAP Library for more details on that.

    By setting the threshold you can easily control when LOBs are loaded to memory.

    - Lars

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.