Re: Concurrently streaming a file to HttpResponse and file IO



Peter Bromberg [C# MVP] wrote:
I'm not convinced the proposed strategy makes a lot of sense -- It would take about the same time to read a resource from the disk as it does to select it out of a SQL server database table. So by having the extra work of storing requested resources in disk files, you might find that you haven't particularly bought yourself much increase in scalability - possibly even a decrease in same.

For many small files it would certainly decrease performance
sine file opening is an expensive process.

But for 32 MB BLOB's it may still be beneficial. At least
if the files are served by IIS not by an ASP.NET page.

Arne
.



Relevant Pages

  • Re: Help installing SQL2000 on Win2003 - MSDTC resources required?
    ... MSDTC resource but you need another physical disk and network name so I ... network name as these resources and in the same group as the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • RE: Failed resources
    ... catastrophic result, when I just move one resource to another node, like the ... > Node A hosts normally SQL Server 2K and File System ... > Cluster resource 'Disk Z:' in Resource Group 'Cluster Group' failed. ... > Cluster resource 'Disk V:' in Resource Group 'SQL Server Group' failed. ...
    (microsoft.public.windows.server.clustering)
  • Re: Creating Database (Urgently need help)
    ... Select the SQL Server group. ... Right click in the SLQ SErver resource, ... physical disk NOT in the list cannot be used for SQL data storage. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issue with Clustering
    ... If you are using a MNS quorum then you do not need a Quorum disk in your ... AddVolume: Adding Name ... waiting for notification from PnP thread that all volumes exist... ... Posting state 4 notification for resource ...
    (microsoft.public.windows.server.clustering)
  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... Bring both resource groups to the node you are logged into. ... I support the Professional Association for SQL Server ... >>> physical disk owened by the first node, ... >>> offline with cluster administrator) WHich is better? ...
    (microsoft.public.sqlserver.clustering)