Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2012
    Posts
    25

    Question Unanswered: Storing LOBs inline in table rows

    In DB2 9.7 you can store LOBs inline in table rows. But i have difficulties to find an optimum length for the LOBs.

    What is an optimum length?? Would 128 kb too big??

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Sure it would, as it clearly exceeds the 32KB page size maximum.

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    You cannot inline whole Lobs whose length exceeds the page size.

    There is no concept of optimal for every situation. Use common sense.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by kotuboy View Post

    What is an optimum length??
    How long is a piece of string?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Mar 2012
    Posts
    25

    2kb to 1500kb

    Hallo,
    we have documents 20kb to 1500kb.

    If i set the length under 10kb. I have nearly no effect. Because there are not so many documents under 10kb.
    I would prefer to set the length between 20kb and 30kb (Thanks for the limitation hint).
    Is it a good idea?
    I am not sure that the performance will be better doing this.
    The table will be bigger and the perfromance will be worse.. ????

    What do you think??

  6. #6
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    If you explained what the application is trying to achieve then perhaps your questions would make more sense. RDBMSs are not by themselves a document management solution.

    Perhaps an experienced solution architect needs to examine your requirements and recommend the best tools for whatever problem you are trying to solve.

  7. #7
    Join Date
    Mar 2012
    Posts
    25

    Application

    Thanks for the help.

    The application manages the sampling process of automobil parts.
    There are lots of information about parts, sampling plans, sampling results, person who are responsible for testing the parts etc.
    In addition to that the person, who checks the part , can add documentation about that part after testing.

    It is possible to see the document if needed.

    I am in a migration phase from 9.5 to 9.7.
    I saw the the new feature about small LOB's. And I try to find out if this feature applies to our program or not.

  8. #8
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Partially-inlined LOBs are suitable for applications where a high percentage of the LOBs are very small sized (so that several can fit into a page). They are unsuitable for large documents, which are better suited for storage outside the database (but possibly linked from the database - as in some content management solutions).
    .

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •