From the Speedb Hive:
you can ask specifically for mmap using the relevant options. The issue is that if you have a large database you will eventually run OOM, the other issue of reading too much was fixed in rocksdb. As for the cache0 vs cache1. In a week we will have a version that includes "static pinning" which includes a pinning of indexes and filter with a safety belt and perform as good as cache1 if you have enough memory but will also have a safety belt to eliminate the OOM worries,.
You can find the Speedb hive
here and (once you've registered) the link to the thread with your question
here, if you have more questions or need additional info