Currently, we have an entry cache configured in the Partition, but it's not set at all. Its default size is 1, when it should be higher. We though never hit the cache, and have to get the data from the partition.
Setting the cache size to a normal value leads to an increased performance of around 10% (we are saving the BTree search, even if the btree caches pages.
We have to get this cache being correctly configured.