StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3886933
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-10-08T00:39:02.690
FavoriteCount
0
LastActivityDate
2010-10-08T00:39:02.690
LastEditDate
LastEditorUserId
0
OwnerUserId
429201
ParentId
3886171
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Rather than an ASP.NET page you should implement an <a href="http://msdn.microsoft.com/en-us/library/system.web.ihttpasynchandler" rel="nofollow">IHttpAsyncHandler</a>. ASP.NET page code puts many things between your code and the browser that would not be appropriate for transferring binary files. Also, since you're attempting to perform rate limitation, you should use asynchronous code to limit resource usage, which would be difficult in an ASP.NET page. Creating an <a href="http://msdn.microsoft.com/en-us/library/system.web.ihttpasynchandler" rel="nofollow">IHttpAsyncHandler</a> is fairly simple. Just trigger some asynchronous operations in the <a href="http://msdn.microsoft.com/en-us/library/system.web.ihttpasynchandler.beginprocessrequest" rel="nofollow">BeginProcessRequest</a> method, and don't forget to properly close the context to show you have reached the end of the file. IIS won't be able to close it for you here. The following is my really bad example of how to perform an an asynchronous operation consisting of a series of steps, counting from 0 to 10, each performed at a 500ms interval. <pre><code>using System; using System.Threading; namespace ConsoleApplication1 { class Program { static void Main() { // Create IO instances EventWaitHandle WaitHandle = new EventWaitHandle(false, EventResetMode.AutoReset); // We don't actually fire this event, just need a ref EventWaitHandle StopWaitHandle = new EventWaitHandle(false, EventResetMode.AutoReset); int Counter = 0; WaitOrTimerCallback AsyncIOMethod = (s, t) => { }; AsyncIOMethod = (s, t) => { // Handle IO step Counter++; Console.WriteLine(Counter); if (Counter >= 10) // Counter has reaced 10 so we stop StopWaitHandle.Set(); else // Register the next step in the thread pool ThreadPool.RegisterWaitForSingleObject(WaitHandle, AsyncIOMethod, null, 500, true); }; // Do initial IO Console.WriteLine(Counter); // Register the first step in the thread pool ThreadPool.RegisterWaitForSingleObject(WaitHandle, AsyncIOMethod, null, 500, true); // We force the main thread to wait here so that the demo doesn't close instantly StopWaitHandle.WaitOne(); } } } </code></pre> You'll also need to register your <a href="http://msdn.microsoft.com/en-us/library/system.web.ihttpasynchandler" rel="nofollow">IHttpAsyncHandler</a> implementation with IIS in whichever way is appropriate for your situation.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy Thread.Sleep() is so CPU intensive?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLunatic Experimentalist
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COI deal with many other things like cookies, redirecting users to other pages (HTTP redirect)... and I'm not sure if I with this solution I need to go deep inside IIS and handle everything myself. I would read about it and vote. Thanks for the hint.
 singulars
 PostPostId
 PO
 UserUserId
 USXaqron

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.