文件流性能 [英] File Streaming Performance

问题描述

我有一个有图像列的表，因此需要文件流技术来提高性能

但是我感到很惊讶因为当我从这个表中选择*时

i找到最慢的性能与Select *相同的架构和数据表相比没有文件流技术



查看统计数据

第一个是表文件流，而第二个没有

i have a table which has an image column so file stream technology is required to enhance the performance
but i am surprised because when i select * from this table
i find slowest performance comparing with Select * from same schema and data table without file streaming technique

see the statistics
first one is the table with file streaming while the second is without

(1206018 row(s) affected)

(1 row(s) affected)

 SQL Server Execution Times:
   CPU time = 43610 ms,  elapsed time = 185441 ms.

(1206018 row(s) affected)

(1 row(s) affected)

 SQL Server Execution Times:
   CPU time = 1937 ms,  elapsed time = 23799 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.

任何评论？

我们在使用时不应该找到更好的表现filestream

Any Comments ?
shouldn't we find better performance when using filestream

推荐答案

性能取决于很多因素...用于存储文件的媒体，SQL与媒体之间的网络速度，您的数据库设计 - 它是否符合FILESTREAM的指导原则？

您应该阅读这些内容并遵循...

FILESTREAM最佳实践 [ ^ ]

FILESTREAM实施的最佳实践 - B log do Ezequiel - 站点主页 - MSDN博客 [ ^ ]

There are a lot of factors that performance depends on...What media used to store the files, how fast the network between the SQL and the media, what your database design - does it fir the guidelines for FILESTREAM?
You should read these and follow...
FILESTREAM Best Practices[^]
Best Practices on FILESTREAM implementations - Blog do Ezequiel - Site Home - MSDN Blogs[^]

这篇关于文件流性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！