locked
Table with varbinary column (Images, Documents...) RRS feed

  • Question

  • Hello,

    I have a table where we save images and documents (Word, PDF) in a varbinary column - the size of these BLOB's are between 100kb and 1MB

    In a screen I have a table which displays the metadata (not the blob) - I show the blobs only in the DocumentViewer (Firtsflow Document Viewer) if the user click's on a link.

    Question:

    • wenn does LS load this column?
      does it load this with the display of the table although the column is not visible?

    for our inhouse client this is not a problem but we are working on a extranet client and there might be a problem if there is a slow connection?

    robert

    Thursday, December 6, 2012 9:22 AM

Answers

  • Robert:

    It is my understanding that all columns are retreived when querying a table.  I have a similar issue and the suggestions for avoiding the problem are:

    1) Create a RIA service that returns only the columns that you need (without the image column).

    2) Create a SQL view to return only the columns that you need.

    3) Store the image data in a separate, related table.

    Mark

    • Proposed as answer by Yann DuranModerator Friday, December 7, 2012 10:21 AM
    • Marked as answer by Angie Xu Thursday, December 20, 2012 1:23 AM
    Friday, December 7, 2012 4:30 AM