Skip to Content
author's profile photo Former Member
Former Member

Limitation on size of record in a table

Hi,

I observe that when I try to insert a record data type "BLOB/XSTRING" with the length of say 60 MB (its a file) fails when the underlying DB is MSSQL. But if the underlying DB is ORACLE, it allows me to insert files up to a length of 80 MB in a single record.

Q1. Are there any standards available (in the form of documentation or otherwise), giving an optimum size for each record when the data type of that attribute is XSTRING/BLOB.

Also let me know the performance hit incase of size when there bytes are retrieved.

With Regards

Murali

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2005 at 10:03 AM

    hi

    1. Ans - Can you call execute a Stored procedure from ABAP

    2. Ans - As far as I know, performance should not be a problem because your query is first converted into an optimzed one before it is queried against the DB.

    plz reward points if it helps!!

    Regards

    Gunjan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2005 at 10:10 AM

    Hi Murali,

    You can refer this link for Database Table limitations:

    http://www.sapdb.org/7.4/sap_db_features.htm

    Regards,

    Raj

    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.