Yo. Today I release new version of RevolveR DBX engine thats supports for now cache segments based on static partitions in JSON format. You can configure how many chunks will be used to split static caches. If rows count are around 0-2000 per table you can adjust $sql_cache_segments value to zero. Also you can configure cache segments for 5 to default for many rows count.
Cache partitions updates automatically after every database change such as delete, insert, update, inject queries.
Now RevolveR DBX under testing and I need some time to update RevolveR CMS code.