SQL Server 2005 Blob数据类型 [英] SQL Server 2005 Blob Data type

问题描述

为什么SQLServer 2005中的Blob(数据类型)需要时间才能从数据库中获取数据?

Why blob (datatype) in SQLServer 2005 takes time for fetching data from database? and how to reduce the time?

推荐答案

BLOB将花费一些时间来获取数据，因为这通常是大量数据(图片，pdf或类似内容) .
您无法减少实际获取BLOB的时间-更快的网络或表结构优化可能会对您有所帮助-但这与BLOB对象本身无关.

BLOB will take time to get data as this is generally a huge amount of data ( a picture, a pdf or something similar).
You cannot reduce time on the actual fetching of the BLOB - a faster network or table structure optimization may help you - but this has nothing to do with the BLOB object per-se.

因为数据很多吗?

将较小的数据写入数据库时​​.

或者，您需要查看速度较慢的地方:可能是在服务器端(不太可能，除非您的数据库设计是完全垃圾的)，在传输本身(可能取决于连接和速度)还是在传输中.查询本身(很可能，但是没有相关的代码片段是不可能的).

Because it is a lot of data?

Use smaller data when you write it to the database.

Alternatively, you need to look at where it is slow: It could be at the server end (unlikely, unless your database design is complete rubbish), in the transfer itself (possible, it depends on the connections and speeds involved) or in the query itself (quite likely, but without the relevant code fragment it is impossible to tell).

这篇关于SQL Server 2005 Blob数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！