Look here: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...

  SELECT $columnEmbedding FROM $tableName LIMIT 10000 OFFSET $offset

They're not using any indexes, because they're doing offset pagination [1] in a loop. And offset pagination is causing them to scan 550K total rows [2] instead of 100K.

OP, change your code. You're probably wrong about SQLite being slower than Isar, or at least it must be very close.

[1] https://use-the-index-luke.com/no-offset

[2] 10K + 20K + 30K + 40K + 50K + 60K + 70K + 80K + 90K + 100K = 550K