Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It all depends on what you are developing for, but here are some rules of thumb.</p> <p>HTTP requests mean overhead (especially over HTTPS) so try to make as little as possible, for mobile this is crucial. there are a few exceptions though; lazy loading JavaScript files which aren't needed when the app initializes is sometimes smart so they're cached when really needed, using a CDN for popular libs sometimes can lead to great performance boost because of paralel downloads.</p> <p>keep downloads as small as possible, so minify all JavaScript and CSS, some even minify HTML.</p> <p>make sure cache headers are set correctly (some set them to a year or more), and when a new version of your script is deployed, append the src attribute of the script element with a version number to counter caching, like: <code>&lt;script src="myapp.js?v=2"&gt;&lt;/script&gt;</code></p> <p>Sometimes perceived performance is better than real performance, meaning; having the HTML loaded and rendered is more important than the application initialized. this can be done by asynchronously loading JavaScript files (by inserting script elements with JavaScript like Google does or by using script loaders which do this for you). but this leads to new challenges like the execution order of loaded files or interacting with the page before the script files are fully loaded and parsed.</p> <p>In the end it's heavily dependent on the architecture of your online app or site and what the interaction with it is or should be, care to elaborate further by giving some examples?</p> <p>PM5544.</p>
    singulars
    1. This table or related slice is empty.
    1. POShould I copy all my JavaScript sources into one single file?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USPM5544
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POShould I copy all my JavaScript sources into one single file?
      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. VTAcceptedByOriginator
    1. COthanks for the great feedback PM5544. I'm particularly curious to learn more about asynchronous js loading to boost performance. Here is an example of a small site I did for a friend to display his artwork: http://tinyurl.com/758ocgo I'm using a few jQuery plugins and would be curious to hear if there's anything I should be doing differently to optimize performance.
      singulars
      1. PO
      1. USnickpish
    2. COIn this specific case i would advise you to do the following; combine the plugins into one JavaScipt file than minify it. move all the `<script>` elements to the bottom of the page and put the Google analtytics all the way at the bottom. combine all css files and remove all useless whitespace (tabs and enters) and combine all functions which run on DOMReady into one function.
      singulars
      1. PO
      1. USPM5544
 

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