I use a small number of key-value pair to test random read of foundation db. It consumed all the disk IO，though I have enought RAM. Why it can’t store all the data in the buffer pool of sqlite?
What is the total size of KV pairs in your database, what is the replication factor, what storage engine are you using and how many storage server processes do you have and what are the values of the configuration parameters
Usually sqlite with
ssd storage engine does not produce disk i/o reads after some time of loading if
total kv size
replication factor <<
number of storage processes