Maximum number of tables

Hi there,

does HeavyDB have a limit for the number of tables that can be created? Other databases - like ClickHouse for example - state that they can only handle a few thousand tables. Is there any such limitation with HeavyDB?


Hi @tholut,

On Heavydb we haven’t such a hard limit, so you can create how many tables you want, but I’m not sure how would perform an application that’s going to use an extremely high number of tables.

Generally, the database that is built to run Analytical queries is optimized for a certain type of workload.

Could you explain in a more detailed way the workload that would need such an high number of tables?