Jump to main content

Nicolas Hoizey

  • articles
  • billets
  • links
  • notes
  • talks
  • archives
  • about

Note from 2 December 2021

  • Nicolas Hoizey
  • 2 December 2021
  • image, WebPerf
  • 37 reactions

Two weeks ago, I used Google BigQuery with HTTP Archive data to find the heaviest images in French government home pages.

Today, I received a bill I didn't anticipate… 😅

Google Cloud bill for BigQuery usage

37 reactions

3 likes

  1. Jakub G avatar
  2. Nicolas Steinmetz avatar
  3. ≠ avatar

1 repost

  1. Cacahuète et nougat avatar

33 replies

  1. Stuart Robson avatar Stuart Robson
    a BigBill.
    • 2 December 2021, 11:13
    • Source
  2. Yoav Weiss avatar Yoav Weiss
    oh my.. :/
    • 2 December 2021, 11:14
    • Source
  3. Nicolas Hoizey avatar Nicolas Hoizey
    It could have been much worse… 😅
    • 2 December 2021, 11:16
    • Source
  4. Jean-Pierre Vincent avatar Jean-Pierre Vincent
    mais lol
    tu avais cramé ton quota de Go gratuit ?
    • 2 December 2021, 11:16
    • Source
  5. Nicolas Hoizey avatar Nicolas Hoizey
    It's not so bad, I guess it could have been worse.

    I don't know if I missed a message somewhere alerting me about this… 🤷‍♂️
    • 2 December 2021, 11:17
    • Source
  6. Cacahuète et nougat avatar Cacahuète et nougat
    @nhoizey 😱
    • 2 December 2021, 11:17
    • Source
  7. Nicolas Hoizey avatar Nicolas Hoizey
    Il faut croire, alors que je ne l'ai pas utilisé depuis très longtemps… 🤷‍♂️
    • 2 December 2021, 11:17
    • Source
  8. Jean-Pierre Vincent avatar Jean-Pierre Vincent
    il me semblait que c'était par mois ce quota pourtant mais peut être que tu as vraiment brassé des To :)
    • 2 December 2021, 11:27
    • Source
  9. Nicolas Hoizey avatar Nicolas Hoizey
    C'est possible, je n'ai pas vraiment fait gaffe au volume de données manipulées, et j'ai fait plusieurs fois les requêtes avant d'arriver au résultat.
    • 2 December 2021, 11:29
    • Source
  10. Nicolas Hoizey avatar Nicolas Hoizey
    For those who didn't follow the link, the list of 1000 heaviest images in French government sites (home pages) is there:
    https://annuel2.framapad.org/p/gouv-lourd-9qv6?lang=enLet's hope some of these will be fixed. 🤞
    Framapad annuel
    • 2 December 2021, 11:33
    • Source
  11. Yoav Weiss avatar Yoav Weiss
    FWIW, I wouldn't expect this particular query to be this expensive. What I usually do is experiment with smaller test tables to get my query right, and only then tackle the real data. The expensive bit is typically the response bodies..
    • 2 December 2021, 11:41
    • Source
  12. Nicolas Hoizey avatar Nicolas Hoizey
    I tried several queries before getting the result I wanted, so I guess I did use a lot of data for some attempts.

    I thought I saved some of them, but I can't find them anymore in BigQuery.
    • 2 December 2021, 12:00
    • Source
  13. Sid Vishnoi avatar Sid Vishnoi
    Is the comma here being used as a thousands separator or a decimal marker?
    • 2 December 2021, 12:32
    • Source
  14. Nicolas Ramz avatar Nicolas Ramz
    Ah quand même: 25Mo!
    aft.gouv.fr/files/2021-07/…
    • 2 December 2021, 12:35
    • Source
  15. webetcaetera avatar webetcaetera
    @nhoizey and the winner is … Photo de groupe avec masque. C’est lourd les masques. 😅
    • 2 December 2021, 12:43
    • Source
  16. Nicolas Hoizey avatar Nicolas Hoizey
    @webetcaetera 😅
    • 2 December 2021, 13:45
    • Source
  17. Nicolas Hoizey avatar Nicolas Hoizey
    It is a decimal marker (I should remove them), weights are in MB.
    • 2 December 2021, 13:52
    • Source
  18. Nicolas Hoizey avatar Nicolas Hoizey
    Il faut bien ça pour arriver à reconnaître tout le monde !
    • 2 December 2021, 13:56
    • Source
  19. Stéphane Deschamps avatar Stéphane Deschamps
    @webetcaetera Note que si on veut voir tous les plis, il faut une TRÈS BONNE définition. @nhoizey
    • 2 December 2021, 14:10
    • Source
  20. Stéphane Deschamps avatar Stéphane Deschamps
    @webetcaetera @nhoizey Notons juste que comme d'habitude, les gens qui recettent ça ne sont vraisemblablement pas dans la situation des utilisateurs-utilisatrices en bout de chaîne, sinon ç'aurait été corrigé avant même la mise en ligne.
    • 2 December 2021, 14:14
    • Source
  21. Simon Pieters 💉💉 avatar Simon Pieters 💉💉
    Set up billing alerts 🚨
    • 2 December 2021, 14:54
    • Source
  22. Nicolas Hoizey avatar Nicolas Hoizey
    @accessiblestef @webetcaetera ou alors, une doc quelque part dit « attention à ne publier que des images légères », sans autre explication.
    • 2 December 2021, 16:50
    • Source
  23. Julien / Sphinx avatar Julien / Sphinx
    @nhoizey whaaaat, s'il faut participer, pas de souci hein ^^
    • 2 December 2021, 16:50
    • Source
  24. Nicolas Hoizey avatar Nicolas Hoizey
    I guess it would not help much in this case where everything was dine in a few minutes, unless they track it in real time?
    • 2 December 2021, 17:17
    • Source
  25. Simon Pieters 💉💉 avatar Simon Pieters 💉💉
    Idk how promptly it alerts
    • 2 December 2021, 17:38
    • Source
  26. Holger Bartel avatar Holger Bartel
    😳
    • 2 December 2021, 17:59
    • Source
  27. Nicolas Hoizey avatar Nicolas Hoizey
    I’ll check what I can do, for next time I use it.
    • 2 December 2021, 19:28
    • Source
  28. Nicolas Hoizey avatar Nicolas Hoizey
    😂
    • 2 December 2021, 19:28
    • Source
  29. Arnaud Limbourg avatar Arnaud Limbourg
    Ah oui tout de même
    • 2 December 2021, 19:58
    • Source
  30. David Larlet avatar David Larlet
    @nhoizey j'y travaille 👍 🙇
    • 3 December 2021, 01:59
    • Source
  31. David Larlet avatar David Larlet
    @nhoizey si ça se trouve tu peux demander une réduction d'impôts 😅
    • 3 December 2021, 02:00
    • Source
  32. Nicolas Hoizey avatar Nicolas Hoizey
    @dav cool !
    • 3 December 2021, 02:01
    • Source
  33. Nicolas Hoizey avatar Nicolas Hoizey
    @dav ah ah ! 😅
    • 3 December 2021, 02:01
    • Source
  • Older: Note from 29 November 2021
  • Newer: Note from 9 December 2021

Related contents with similar topics

  1. screenshot of JPEG XL vs AVIF for web use-cases

    Jake Archibald avatar Jake Archibald

    JPEG XL vs AVIF for web use-cases

    • Nicolas Hoizey
    • 22 October 2026
    • WebPerf, image, JPEG XL, AVIF
    • 5 reactions

    I'll go into full detail, with examples and benchmarks, but for those of you who don't have the time, here are [2 of] the headlines: For lossy photos…

  2. screenshot of The case against JPEG XL

    Gianni Rosato avatar Gianni Rosato

    The case against JPEG XL

    • Nicolas Hoizey
    • 14 September 2026
    • WebPerf, image, JPEG XL, AVIF
    • 7 reactions

    JPEG XL isn't useless; it is genuinely compelling technology for use cases beyond the Web. I'm just not personally convinced we need it in browsers…

  3. screenshot of The present and potential future of progressive image rendering

    Jake Archibald avatar Jake Archibald

    The present and potential future of progressive image rendering

    • Nicolas Hoizey
    • 16 October 2025
    • image, WebPerf
    • 4 reactions

    So if the browser manages to download 6 kB then stalls, then AVIF can produce a better result. But since the AVIF rendering is only two-pass, if the…

  4. screenshot of JPEG VS AVIF - The Battle of Compression

    kliksphilip

    JPEG VS AVIF - The Battle of Compression

    • Nicolas Hoizey
    • 25 September 2024
    • image, WebPerf, AVIF, JPEG XL
    • 2 reactions

    In this super thorough study I test one single HD image and come to vast sweeping conclusions about JPEG XL and AVIF. But that's still one image comparison…

  5. Note from 24 April 2024

    • Nicolas Hoizey
    • 24 April 2024
    • image, JPEG XL, Lighthouse, photography, WebPerf
    • 3 reactions

    Should I please Lighthouse with modern image formats, or my visitors with progressive rendering of large images in my photography site? 🤔

    screenshot of Lighthouse score in SpeedCurve, with a recommendation to use modern image formats

    Of course, this would be much easier with genaralized JPEG XL support, both modern and allowing progressive… 🤷‍♂️

If you want to share an error or suggest an enhancement of this content, please edit the source on GitHub.

© Nicolas Hoizey

Built with Eleventy