SQL Server Performance

Rich Edit Component

Discussion in 'SQL Server 2008 General Developer Questions' started by seemun, Feb 28, 2010.

  1. seemun New Member

    Hi,
    If we use RichEdit component to insert picture and text into varchar(max) field, the performance is very slow, any advise how to keep it ?
    Please suggest and show example how to do it.
    Thanks.
    rgds/seemun
  2. Adriaan New Member

    I doubt very much that you can insert a picture into a varchar(max) column, which supports only alphanumeric data (not binary).
    The usual suggestion is to store only the path to an external document in your database.
  3. satya Moderator

  4. moh_hassan20 New Member

    [quote user="satya"]FILESTREAM will help[/quote]
    I agree with satya for using FileStream for storing binary data.
    File streams were introduced in SQL Server 2008 and offer the capability to store binary data to the database but outside the normal database files.

    The binary data is stored in a special folder structure which is managed by the SQL Server engine. Only , a pointer to the file is saved in the database.
    That is enhance the performance of uploading/downloading binary data: images , ritch text and others from/to database.

Share This Page