Click here to Skip to main content
15,887,676 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
C#
(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.


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

1 solution

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[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900