https://sqlfordevs.com/ebooks/indexing

You could reduce your image weight by around: 2,400kb (62%)

Analysis date: April 22, 2024

36 images were found on this page from sqlfordevs.com. Below is a breakdown of approximately how much page weight you could save if they were optimized with PicPerf. Any images already being optimized by PicPerf are ignored.

Aside from being optimized, each of these images would be automatically aggressively cached on visitors' devices, as well as on a global CDN. Pictures will be faster, and served in the format (WebP or AVIF) best suited for a great experience on the web. The more you have, the stronger the gains.

About These Numbers

This analysis was run by loading the page on a simulated mobile device. The page was then scrolled all the way to the bottom, so that lazily-loaded images had a chance to play too. Every image loaded throughout that process was then run through a series of optimizations, after which the numbers were crunched.

Image

Original Size

Optimized Size

Savings

https://sqlfordevs.com/build/assets/moon.a2c6b02a.png

79kb

25kb

68%

https://sqlfordevs.com/build/assets/book.4c9d80b5.png

530kb

200kb

62%

https://sqlfordevs.com/build/assets/testimonial-caleb-porzio.11ce1fba.jpg

4.4kb

2.5kb

44%

https://sqlfordevs.com/build/assets/testimonial-taylor-otwell.4d97426e.jpg

5.1kb

3kb

41%

https://sqlfordevs.com/build/assets/testimonial-aaron-francis.2b9b1cb0.jpg

5.6kb

3.7kb

35%

https://sqlfordevs.com/build/assets/sign-in.451fe2b1.svg

38kb

32kb

15%

https://sqlfordevs.com/build/assets/tobias-petry.8b749b8b.jpeg

19kb

9.8kb

48%

https://sqlfordevs.com/build/assets/testimonial-stef-rouschop.8dedaf38.jpg

7.2kb

3.1kb

57%

https://sqlfordevs.com/build/assets/testimonial-tim-geisendoerfer.453f0950.jpg

3.2kb

1.7kb

47%

https://sqlfordevs.com/build/assets/testimonial-michael-daly.2333b087.jpg

4.9kb

2.7kb

44%

https://sqlfordevs.com/build/assets/teaser-clustered.925c61f7.png

120kb

70kb

40%

https://sqlfordevs.com/build/assets/teaser-inequality.e36aa886.png

110kb

72kb

35%

https://sqlfordevs.com/build/assets/teaser-aggregation.81ffac66.png

120kb

78kb

34%

https://sqlfordevs.com/build/assets/teaser-notusingindex.fc36ba24.png

130kb

86kb

34%

https://sqlfordevs.com/build/assets/teaser-columndistribution.ae438065.png

110kb

71kb

35%

https://sqlfordevs.com/build/assets/teaser-leadingwildcard.9349783a.png

120kb

82kb

31%

https://sqlfordevs.com/build/assets/teaser-boundingbox.fe140df2.png

140kb

85kb

38%

https://sqlfordevs.com/build/assets/chapter-1.ce474a8f.jpg

510kb

62kb

88%

https://sqlfordevs.com/build/assets/chapter-3.393a0ccb.jpg

260kb

32kb

88%

https://sqlfordevs.com/build/assets/chapter-4.64303e7a.jpg

310kb

37kb

88%

https://sqlfordevs.com/build/assets/chapter-5.aaf44ba4.jpg

530kb

52kb

90%

https://sqlfordevs.com/build/assets/video-explain.a94d0490.jpg

150kb

97kb

37%

https://sqlfordevs.com/build/assets/video-join-subquery.d41c1b3d.jpg

150kb

100kb

32%

https://sqlfordevs.com/build/assets/video-query-and-schema.de313394.jpg

100kb

65kb

37%

https://sqlfordevs.com/build/assets/pricing-tier-dots.97a5be11.svg

6.4kb

5.4kb

15%

https://sqlfordevs.com/build/assets/paypal.b5b16a1f.svg

5.2kb

4.2kb

19%

https://sqlfordevs.com/build/assets/apple-pay.307168ea.svg

1.8kb

1.6kb

15%

https://sqlfordevs.com/build/assets/visa.d238f5c1.svg

3.1kb

2.4kb

21%

https://sqlfordevs.com/build/assets/mastercard.d4957bb3.svg

6.5kb

5.5kb

15%

https://sqlfordevs.com/build/assets/amex.08215c85.svg

1.7kb

1.3kb

26%

https://sqlfordevs.com/build/assets/discover.d18d59f0.svg

8.1kb

6.7kb

18%

https://sqlfordevs.com/build/assets/faq-squares.7503bbed.png

12kb

6.8kb

44%

https://sqlfordevs.com/build/assets/stickout-clustered.b48b4ecf.png

46kb

24kb

49%

https://sqlfordevs.com/build/assets/stickout-aggregate.fb731394.png

60kb

39kb

35%

https://sqlfordevs.com/build/assets/stickout-columndistribution.126fae49.png

44kb

28kb

36%

https://sqlfordevs.com/build/assets/stickout-boundingbox.fc7d6ae3.png

53kb

26kb

52%