Maximum number of tables

Follow

Thomas Lutterbeck

• May 19, 2022 10:32

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?

Best, Thomas

0

• 

  Candido Dessanti

  • May 19, 2022 11:00

  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?

  Regards, Candido

  0

  Comment actions Permalink

Please sign in to leave a comment.