Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>Comet or Websockets</h2> <p>HTML5's <a href="http://dev.w3.org/html5/websockets/" rel="nofollow">websockets</a> (as mentioned in other answers here) may have limited browser support at the moment, but using long-lived HTTP connections to push data (aka <a href="http://en.wikipedia.org/wiki/Comet_%28programming%29" rel="nofollow">Comet</a>) gives you similar "streaming" functionality in a way that <a href="http://cometdaily.com/2007/10/25/http-streaming-and-internet-explorer/" rel="nofollow">even IE6</a> can cope with. Comet is rather tricky to implement though, as it is kind of a hack taking advantage of the way browsers just happened to be implemented at the time.</p> <p>Also note that both techniques will require your server to handle a lot more simultaneous connections than it's used to, which can be a problem even if they're idle most of the time. This is sometimes referred to as the <a href="http://en.wikipedia.org/wiki/C10k_problem" rel="nofollow">C10K problem</a>.</p> <p>This article has some discussion of <a href="http://www.infoq.com/news/2008/12/websockets-vs-comet-ajax" rel="nofollow">websockets vs comet</a>.</p> <h2>Reducing header size</h2> <p>You may have some success reducing the HTTP headers to the minimum required to save bytes. But you will need to keep <code>Date</code> as this is not optional according to the spec (<a href="http://tools.ietf.org/html/rfc2616" rel="nofollow">RFC 2616</a>). You will probably also need <code>Content-Length</code> to tell browser the size of the body, but might be able to drop this and close the connection after sending the body bytes but this would prevent the browser from taking advantage of HTTP/1.1 persistent connections.</p> <p>Note that the <code>Server</code> header is not required, but Apache doesn't let you remove it completely - the <a href="http://httpd.apache.org/docs/2.0/mod/core.html#servertokens" rel="nofollow">ServerTokens</a> directive controls this, and the shortest setting results in <code>Server: Apache</code> as you already have. I don't think other webservers usually let you drop the <code>Server</code> header either, but if you're on a shared host you're probably stuck with Apache as configured by your provider.</p>
    singulars
    1. This table or related slice is empty.
    1. POChecking for updates using AJAX - bandwidth optimization possibilities?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDay
    1. USDay
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for your explanation. I'm not going to slow down the shared server I'm using, and 'hacks' are not my first choice either. Thanks about the headers part. I'll see how much I can drop. Also, removing some request headers will save some bandwidth (seems like it cannot be removed from an XMLHttpRequest, but setting it to an empty string leads to the shortest amount of bytes)
      singulars
      1. PO
      1. USpimvdb
 

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