Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here's a few things that may help you:</p> <p>EDIT: I tried the second tip in the list below (tinypng.com) and it reduced the size of your image with 71% to 39.1 KB. So that's a big win.</p> <ol> <li><p>Make sure to set the cache headers on your webserver so that the browser can cache the file. Also use the same URL for all other times you use the image. Doing these two simple things will make sure that the image will only get downloaded the first time the browser requests it. All other times it will be loaded from the browser's cache.</p></li> <li><p>Make sure to check if the image is as small as it can be. If you use a PNG then use tools like <a href="https://tinypng.com/" rel="nofollow">https://tinypng.com/</a> to squash all metadata out of the image. If you use a JPEG then maybe lower its quality. If you use Photoshop make sure to "save the image for web". This will also reduce the size. For photographs you are mostly better of using JPEGs, for text or other images that need to be lossless use PNG or GIF. </p></li> <li><p>Loading images will not really slow down your page that much. Not like JavaScript anyway. Loading Javascript will block the rendering of the page until the JS file is downloaded unless you use special loading techniques. That is not the case for images: the page will continue being rendered and the user can start using the page. </p></li> <li><p>If the image is placed using an IMG tag the make sure to set the width and the height of the image in the CSS (or using the img width and height attributes). That will make sure that the browser does not need to reflow the page when the image is downloaded. It will know what size it needs to be even before the image is downloaded. </p></li> <li><p>There is a maximum number of parallel requests per domain that the browser will do. If the image has a very low priority you could postpone its loading and wait for the onLoad event. This will make sure the other resources (with a a higher prio) will be downloaded first. This will require some JavaScript, but not that much (Use an image lazy loader, there are many). </p></li> <li><p>As I said in the previous item the are a maximum number of requests PER DOMAIN. This is why you could also create a new (sub)domain and load some content from there. It will increase the total number of resources that will be downloaded in parallel. using a CDN will also help here because they also have a separate domain (and they are optimised as well).</p></li> <li><p>If you want to read some REALLY GOOD books about this kind of optimising, read these: <a href="http://rads.stackoverflow.com/amzn/click/0596529309" rel="nofollow">http://www.amazon.com/High-Performance-Web-Sites-Essential/dp/0596529309</a> <a href="http://rads.stackoverflow.com/amzn/click/0596522304" rel="nofollow">http://www.amazon.com/Even-Faster-Web-Sites-Performance/dp/0596522304</a></p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POMost effective way to import large images?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USkoenpeters
    1. USkoenpeters
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMost effective way to import large images?
      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. VTAcceptedByOriginator
    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. COAlright, thanks for the great answer!
      singulars
      1. PO
      1. USuser3049858
    2. COyou're welcome.
      singulars
      1. PO
      1. USkoenpeters
 

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