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
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.
It depends on the volume of that data, as usual managing IMAGE based data will be a slow process to perfom as per RDBMS concepts. You can take help of .NET in this case or even FILESTREAM will help to some extent see http://www.codeguru.com/csharp/csharp/cs_controls/richtext/article.php/c7529 fyi
[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.