But as a percentage of all sites that use preload (the ~2.5 million): 235,535 / 2,506,138 = 0.09 = 9% 228,895 / 2,506,138 = 0.09 = 9% so about 18% combined (round up to say 20% for the leftovers that uselessly preload more than 2 resources). Hope that helps :) - ThreadSky

About ThreadSky

programmingart.bsky.social • 79 days ago

But as a percentage of all sites that use preload (the ~2.5 million):

235,535 / 2,506,138 = 0.09 = 9%
228,895 / 2,506,138 = 0.09 = 9%
so about 18% combined (round up to say 20% for the leftovers that uselessly preload more than 2 resources).

Hope that helps :)

Comments

kojordan.com•78 days ago

Thanks for taking the time to answer.

Leftovers seem to amount to 200,000 pages as well, so let's meet in the middle? :)

I originally thought that missing `crossorigin` on font preloads, could be a big contributing factor to unused preload hints. ...

kojordan.com•78 days ago

But running a query on a small sample of the all.pages table, indicates that less 2% of pages with link[rel=preload][as=font] tags have at least one of those tags with a missing crossorigin attribute.
https://gist.github.com/ko-jordan/577b53ebb18e779c98b13b1c7779993a

programmingart.bsky.social•78 days ago

Hmz that's indeed much lower than I would have expected... Maybe @tunetheweb.com can have a look once he's less busy? 😇

tunetheweb.com•78 days ago

Yup looks to be the case. Even when run on the whole dataset:
https://docs.google.com/spreadsheets/d/1U_dEH_d6VlBZJZEG-GCGr0g1ET6DHB0SUK5icLFg5QI/edit?gid=1037011126#gid=1037011126

That's good! Expected it to be much higher.

FYI: @paulcalvano.bsky.social - a non-mistake to add to your list 😀

sia.codes•78 days ago

If you use the new crawl tables, it might be cheap to run it without samples. This was the case for me. An $80 query went down to only 15GB

It was easier for me to migrate the query than I was expecting:
https://har.fyi/guides/migrating-to-crawl-dataset/

kojordan.com•78 days ago

Thanks for the hint. 🙏

I updated the query now to use the crawl.pages and it's 5 times cheaper! Also, the query looks a bit nicer. 😍

Posting Rules

Be respectful to others
No spam or self-promotion
Stay on topic
Follow Bluesky's terms of service

Comments

Posting Rules

Reply