Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What I would do is use the not so well-known ASP.NET <a href="http://msdn.microsoft.com/en-us/library/12s31dhy%28v=vs.80%29.aspx" rel="nofollow">Response.TransmitFile</a> method, as it's very fast (and possibly uses IIS kernel cache) and takes care of all header stuff. It is based on the Windows unmanaged <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms740565%28v=vs.85%29.aspx" rel="nofollow">TransmitFile</a> API.</p> <p>But to be able to use this API, you need a physical file to transfer. So here is a pseudo c# code that explain how to do this with a fictional myCacheFilePath physical file path. It also supports client caching possibilities. Of course, if you already have a file at hand, you don't need to create that cache:</p> <pre><code> if (!File.Exists(myCacheFilePath)) { LoadMyCache(...); // saves the file to disk. don't do this if your source is already a physical file (not stored in a db for example). } // we suppose user-agent (browser) cache is enabled // check appropriate If-Modified-Since header DateTime ifModifiedSince = DateTime.MaxValue; string ifm = context.Request.Headers["If-Modified-Since"]; if (!string.IsNullOrEmpty(ifm)) { try { ifModifiedSince = DateTime.Parse(ifm, DateTimeFormatInfo.InvariantInfo); } catch { // do nothing } // file has not changed, just send this information but truncate milliseconds if (ifModifiedSince == TruncateMilliseconds(File.GetLastWriteTime(myCacheFilePath))) { ResponseWriteNotModified(...); // HTTP 304 return; } } Response.ContentType = contentType; // set your file content type here Response.AddHeader("Last-Modified", File.GetLastWriteTimeUtc(myCacheFilePath).ToString("r", DateTimeFormatInfo.InvariantInfo)); // tell the client to cache that file // this API uses windows lower levels directly and is not memory/cpu intensive on Windows platform to send one file. It also caches files in the kernel. Response.TransmitFile(myCacheFilePath) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to deliver big files in ASP.NET Response?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSimon Mourier
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONope, we have about million files, and we want to stream blocks from databases directly, extracting blocks and creating temp file will add overhead of managing and deleting it. I want to find out the cause of problem, not alternative.
      singulars
      1. PO
      1. USAkash Kava
    2. CO@AkashKava- These are not "temp" files, but instead cached files that will be reused on subsequent requests. Extracting files from a database at each request is not very good, hence the cache story that leverages Windows hi-perf lower IO layers. And storing millions of files on a disk is not more an issue than storing millions of files in a database. This is a solution to the problems you describe.
      singulars
      1. PO
      1. USSimon Mourier
    3. COWe are dealing with our millions of files in database since last 7 years, till IIS 6.0 everything was alright, this problem started recently in IIS 7.0 as we upgraded our servers. "Extracting files from a database at each request is not very good", do you have any performance benchmarks? How do you make your data access ACID compliant with just files on the disk? These questions are out of our scope, I want to get down to bottom of why IIS is behaving strange.
      singulars
      1. PO
      1. USAkash Kava
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload