SQL Server Performance

insert binary data into image data column using SP

Discussion in 'General Developer Questions' started by JHP, Jul 29, 2003.

  1. JHP New Member

    from the VB sql server performance tip article<br /><br />"If your application needs to insert a large binary value into an image data column, perform this task using a stored procedure, not using an INSERT statement embedded in your application. The reason for this is because the application must first convert the binary value into a character string (which doubles its size, thus increasing network traffic and taking more time) before it can be sent to the server. And when the server receives the character string, it then has to convert it back to the binary format (taking even more time). Using a stored procedure avoids all this. [6.5, 7.0, 2000] "<br /><br />the question is... how do I write such stored procedure...[}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />
  2. satya Moderator

  3. vbkenya New Member

    AppendChunk always worked for me outside a stored procedure implementation. Sometimes the convenience of coding (and effectiveness of a methodology) might override the need for performance.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com

Share This Page