Hacker GitHub

← All repos

ente/edge-db-benchmarks

View on GitHub ↗ ★ 2 C++ archived

Benchmarking SQLite vs. ObjectBox vs. Isar

11 mentions on Hacker News by 4 people: 0 stories, 11 comments · first 2024-02-07 · latest 2024-02-07

Mentions per year 11 mentions · busiest year 2024 (11)
20082026
AllStoriesComments NewestTopOldest
  1. …but there's room for optimization. Thanks a bunch for sharing this, I will update the post. [1]: https://github.com/ente-io/edge-db-benchmarks/commit/51ec496...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  2. https://github.com/ente-io/edge-db-benchmarks/blob/43273607d... If this is how you are doing reads, this is your problem. Limit/offset reads are slow. You'll get much better results if you do a proper pagination implementation. This…
    comment by cogman10 · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  3. …deserialization took: 4268 ms ... [log] Isar: 100000 embeddings retrieved in 616 ms ``` [1]: https://github.com/ente-io/edge-db-benchmarks/commit/e02c3d3...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  4. …up the deserialization during reads, please do share. We'd be happy to go back to SQLite. [1]: https://github.com/ente-io/edge-db-benchmarks
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  5. 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…
    comment by SPBS · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  6. The code was always calling the latter[1], I had pasted the incorrect link. [1]: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  7. …with deserializing the read data into models that pushed us to look at options outside SQLite. [1]: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  8. Hey, the writes were batched[1]. What is expensive here is the serialization. [1]: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d... Edit: Updated the permalink
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  9. Sorry, we should have linked to the DB Schema. Here you go: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  10. You don't seem to be using the WAL or any other SQLite optimizations. https://github.com/ente-io/edge-db-benchmarks/blob/main/lib/... Any reason for that?
    comment by yellow_lead · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar
  11. Hello! OP here. Snippets are available @ https://github.com/ente-io/edge-db-benchmarks/blob/main/lib/...
    comment by vishnumohandas · 2024-02-07 · in SQLite vs. ObjectBox vs. Isar