How to Delete Unused Assets from Large Dataset - Timeout Error

1 replies

Last updated: Mar 23, 2021

Hey everybody, can somebody advise me on how to deal with deleting unused assets from a large dataset, my query gives me a timeout error. It works ok for smaller dataset. I would appreciate any help!

*[ _type in ["sanity.imageAsset", "sanity.fileAsset"] &amp;&amp; count(*[ references(^._id) ]) == 0 ] [0..99]

Mar 23, 2021, 12:20 PM

Found a way around, just needed to reduce size of batch.. From [0..99] to [0..1]

Mar 23, 2021, 12:40 PM

Sanity– build remarkable experiences at scale

The Sanity Composable Content Cloud is the modern headless CMS that treats content as data to power your digital business. Free to get started, and pay-as-you-go on all plans.

Get started Watch demo

Categorized in

Topic	Categories	Featured	Last Updated
After adding the subtitle and running this code npm run graphql-deploy It does nothing	GraphQL Studio Deploy	Not featured	Sep 15, 2020
how to limit a reference to just one entry in Studio reference input side versus the default as-many-entries-as-you-fill-in-an-array...	Reference Studio	Not featured	Sep 18, 2020
Is it possible to fetch more than one "_type" using GROQ?	GraphQL GROQ Schema	Not featured	Nov 2, 2020
I want to add a view with the Structure builder (S.view.component) where I list similar documents based on the title. What...	GROQ Studio Structure builder	Not featured	Sep 23, 2020
Is there a structure builder example where the format of each preview for the document list is modified?	Schema Previews Structure builder	Not featured	Feb 3, 2021
I have an array of references to a country schema type but it always just returns NULL values for me	Queries Reference Schema	Not featured	Jan 30, 2021
Hi, I need help with a query for getting the url of an image asset. Here is what I've been trying, but I only get the _ref...	Queries GROQ Images	Not featured	Dec 1, 2020
Sanity UI looks brilliant :smiley: Is something like the current date picker possible at the moment? I’m not sure if anicon...	Sanity UI Studio	Not featured	Dec 21, 2020
Hey everyone. I have been coding and may have potentially accidentally deleted something. Does anyone know how to resolve...	Studio	Not featured	Dec 26, 2020
Hello everyone and happy new year :raised_hands::skin-tone-2:, I have a problem with outputting Portable Text :disappointed:...	Portable Text Studio	Not featured	Jan 1, 2021

Topic

Categories

Featured

Replies

Last Updated

After adding the subtitle and running this code npm run graphql-deploy It does nothing

Sep 15, 2020

how to limit a reference to just one entry in Studio reference input side versus the default as-many-entries-as-you-fill-in-an-array...

Sep 18, 2020

Is it possible to fetch more than one "_type" using GROQ?

Nov 2, 2020

I want to add a view with the Structure builder (S.view.component) where I list similar documents based on the title. What...