Slow deletion (and insertion) of large number of elements

[JonPichel]

Hi, I have a store containing around 500000 rows. When I invoke this code:

 await db.dataRecords
    .where("filename")
    .anyOf(...filenames)
    .delete()

With filenames being just 1 filename of around 450000 elements, it takes around 4 minutes to complete the deletion.

This is the code of my database:

import Dexie, { Table } from "dexie"
import { DataRecord } from "src/asterix"

export interface DataRecordDB {
  filename: string
  record: DataRecord
}

export class AsterixDexie extends Dexie {
  dataRecords!: Table<DataRecordDB>

  constructor() {
    super("AsterixDB")
    this.version(1).stores({
      dataRecords: "++,filename,record.category,record.aircraftID",
    })
  }
}

const db = new AsterixDexie()

export default db

Is this just all the performance IndexedDB has to offer, or am I doing something wrong?

When I insert the 450 thousand elements of the file, the insertion also takes a lot of time (around 1 minute).