How to delete unused assets from large dataset without timeout errors?

import {createClient} from '@sanity/client'

const client = createClient({
  projectId: 'your-project-id',
  dataset: 'your-dataset',
  token: 'your-token',
  apiVersion: '2024-01-01',
  useCdn: false
})

async function deleteUnusedAssets() {
  // Get all assets
  const assets = await client.fetch(
    `*[_type in ["sanity.imageAsset", "sanity.fileAsset"]] {_id, _type}`
  )
  
  console.log(`Found ${assets.length} total assets`)
  
  // Check each asset in batches
  const batchSize = 10
  let deleted = 0
  
  for (let i = 0; i < assets.length; i += batchSize) {
    const batch = assets.slice(i, i + batchSize)
    
    await Promise.all(batch.map(async (asset) => {
      // Check if this specific asset is referenced
      const references = await client.fetch(
        `count(*[references($id)])`,
        { id: asset._id }
      )
      
      if (references === 0) {
        await client.delete(asset._id)
        deleted++
        console.log(`Deleted ${asset._id}`)
      }
    }))
    
    console.log(`Processed ${Math.min(i + batchSize, assets.length)}/${assets.length}`)
  }
  
  console.log(`Deleted ${deleted} unused assets`)
}

deleteUnusedAssets()

// First, get all referenced asset IDs
const referencedAssets = await client.fetch(
  `array::unique(*[][_type match "sanity.*Asset"]._ref)`
)

// Then get all assets
const allAssets = await client.fetch(
  `*[_type in ["sanity.imageAsset", "sanity.fileAsset"]]._id`
)

// Find the difference
const unusedAssets = allAssets.filter(id => !referencedAssets.includes(id))

// Delete in batches
for (const assetId of unusedAssets) {
  await client.delete(assetId)
}