Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>To expand a bit on Mr. Martin's response: (beware, this is highly simplified) The job of the OS is to handle those things which the program doesn't want to odo for itself - like handle I/O interrupts and schedule multiple tasks to share the machine. In a perfect world on a machine running one application program, the program would have control of the CPU until it needed the OS to do something for it, like read the next record from a disk file (which calls layered 'services' to figure out which disk, which file, which record, which byte and calculate which disk block on which track to ask fro from the disk controller. A typical 'real' machine also has a bunch of background tasks running, keeping the screen updated, reading the clock, checking for new mail, downloading patches, etc. This is where priorities come in. some tasks run at lower priority, because we don't care when they're done, like updating the system tray icon in Windows for New Mail notification. Other tasks run at a high priority, but are very short, like following the mouse on the screen and changing it from a pointer to a hand. Keep in mind that a typical task only does a few hundred instructions before needing some OS service and going to sleep while it happens. Large applications may have hundreds of thousands of 'instructions,' but again spend some of thir time waiting for something else, from a button push or keyboard entry to a response from a database lookup on another machine. The most CPU intensive applications like calculating Pi to a million decimal places may consume 99.9% of the processor for long periods, but the OS is going to interrupt it periodically just to see if something else needs to be done. Back in the days of DOS (1980's) the program could actually take the who CPU for awhile, but if it needed to read or write or type something to the screen, it would have to as the BIOS to do that, unless the program was written to do those basic operations itsef. Some of this is how computer games respond, by doing the specific operations needed to modify the screen directly, and read directly from the keyboard or mouse device buffers, bypassing the OS. Hopefully, I haven't confused you more... </p>
    singulars
    1. This table or related slice is empty.
    1. POInstructions per sec for Operating systems
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USTom Cunningham
    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
    1. This table or related slice is empty.
 

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