What are the performance implications of using a single large stream versus several smaller ones?

Question

I am using streams to store the hash to database records for a number of tables on chain. Is it recommended to use a single stream to store all the hash for all tables using table name as key. Or is it better in terms of scalability and performance wise to store them in separate streams?

Answer 1

There is no significant difference in terms of performance, you should use separate streams if it makes sense for the logic of your application – otherwise there is no need.