快速检索Varbinary数据 [英] Retrieve VarBinary Data quickly

问题描述

大家好，



我有桌面存储图片作为Varbinary（Max）列中的二进制值。现在我有7组记录，都有varbinary值。使用以下查询检索这些数据大约需要20秒

Hi All,

I have table to store Picture as binary value in Varbinary(Max) column. Right now am having 7 set of records which all has the varbinary value. It takes around 20 seconds to retrieve those data using following query

Select Id,Name,ImageData,Date
From ContentPicture

如果7条记录本身为20秒，则需要更多时间来检索更多记录。你能否建议我如何有效地检索这些记录。



我将这些二进制数据转换成图像并在我的应用程序中显示，所以完全需要2 - 3分钟，以显示图像。



请帮帮我...



提前感谢。

If 7 records itself makes 20 seconds , then it will take much more time for retrieve more records. Can you please suggest me to how to retrieve those records efficiently.

I am converting those binary data into image and displaying in my application, so totally it takes 2 - 3 mins to display an image.

Please help me out...

Thank in advance.

推荐答案

为了优化数据库查询，请将基本64格式的图像保存为数据库中的字符串值。将图像字段的数据类型作为BLOB。



它将显着增加数据库查询

In order to optimize the database query, save the image in base 64 format, as string value in database. Take the data type for the image field as BLOB.

It will dramatically increase the database query

这篇关于快速检索Varbinary数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！