Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>1. Asynchronous Delegates</strong></p> <blockquote> <p>Asychronous calling is used when you have work items that should be handled in the background and <em>you care when they finish</em>.</p> </blockquote> <p><a href="https://stackoverflow.com/questions/1506838/backgroundworker-vs-background-thread/1507337#1507337">BackgroundWorker vs background Thread</a></p> <p><strong>2. BackgroundWorker</strong></p> <blockquote> <ul> <li><strong>Use BackgroundWorker</strong> if you have a single task that runs in the background and <em>needs to interact with the UI.</em> and use it if <em>you don't care when they finish</em> their task. The task of marshalling data and method calls to the UI thread are handled automatically through its event-based model. </li> <li><strong>Avoid BackgroundWorker</strong> if (1) your assembly does not already reference the System.Windows.Form assembly, (2) you need the thread to be a foreground thread, or (3) you need to manipulate the thread priority.</li> </ul> </blockquote> <p><strong>3. ThreadPool</strong> </p> <blockquote> <ul> <li><strong>Use a ThreadPool</strong> thread when efficiency is desired. The ThreadPool helps avoid the overhead associated with creating, starting, and stopping threads. </li> <li><strong>Avoid using the ThreadPool</strong> if (1) the task runs for the lifetime of your application, (2) you need the thread to be a foreground thread, (3) you need to manipulate the thread priority, or (4) you need the thread to have a fixed identity (aborting, suspending, discovering).</li> </ul> </blockquote> <p><strong>4. Thread class</strong></p> <blockquote> <ul> <li><strong>Use the Thread class</strong> for long-running tasks and when you require features offered by a formal threading model, e.g., choosing between foreground and background threads, tweaking the thread priority, fine-grained control over thread execution, etc.</li> </ul> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POAsynchronous Delegates Vs Thread/ThreadPool?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USclaws
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAsynchronous Delegates Vs Thread/ThreadPool?
      singulars
      1. PTQuestion
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAnother case for using the thread class (#4) rather than any thread-pool-based alternative (#1-#3): If you use any classes that store object references in thread-static fields, the direct or indirect targets of those references will not become eligible for garbage collection unless or until either the references are deleted or the thread containing them exits. If thread-static references are stored on a thread-pool thread, it's possible they'll remain there indefinitely, possibly creating a massive memory leak.
      singulars
      1. PO
      1. USsupercat
    2. COThis seems to be the best answer, however it is a bit concerning that no-one has mentioned ThreadPool saturation or suggested that the time to run the delegate affects your decision. ThreadPool/TaskPool is for quickly getting work done on a background thread, but should be limited to work that takes less than say 50-150ms. Putting heavy work (ie longer than 150ms) can lead to thread pool saturation and then you can get nasty 500ms delays while th ThreadPool resizes.
      singulars
      1. PO
      1. USLee Campbell
 

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