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