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?
1 Like
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 memory and storage_memory?
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 * storage_memory
1 Like