Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Why does Bit9 recommend the entire database be on the same partition?

Why does Bit9 recommend the entire database be on the same partition?

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.

Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎01-07-2015
Views:
395
Contributors