Version
All.
Topic
Bit9 SQL database recommendations for best performance.
Q/A
Question
Why does Bit9 recommend that the entire database be on the same partition?
Answer
Partitioning data spreads it out and therefore, when possible, is better to not do it. Having the data spread out makes query more taxing as it has to look in multiple places for the data. Partitioning is the process of dividing up a single large table into multiple logical chunks in such a way that each partition can be managed separately without having much overall impact on the availability of the table, which is necessary and even beneficial in certain scenarios. However, our largest tables (antibodies, Filenames and Pathnames) don't really have the data organized in logical chunks where partitioning could help. Our large tables don't have the type of relationship where they are subsets of filenames and pathnames, so since they are not really able to be broken down into smaller logical chunks of data, it is beneficial to the application that they are in a single partition that can be queried most effectively for best performance.