greenart7c3 on Nostr: Yea, essentially the main issue with performance on citrine was that I was not using ...

Yea, essentially the main issue with performance on citrine was that I was not using suspend functions in the room dao operations, it would lock the database until a query completes and it would not cancel coroutines when needed.
I haven't done any benchmarks but using lmdb from rust-nostr seens faster, don't have the 100-200 memory limit of android apps but I loose everything else like flows, group events by kind etc
Haven't tried nostrdb yet
Using sqlite I still have to test if I can improve some index and I always have to remember of the memory limitations, if anything tries to get all events from a big database I have a oom and the app crashes