We have a business case where we have to frequently write and query multichain streams. To improve the performance, we are writing to a primary node and querying to a secondary node of blockchain network.
But the problem is that when primary node is writing, sync speed is almost 1 block per minute. And when primary node is idle it's still 3 blocks per minute. Sometimes it takes weeks for secondary node to catch up which is not idle for our business case where customers can query the data within 2-3 days of writing.