What are the disadvantages of using a large database?
At first glance, a large database, which may increase significantly in size, does not have any major negative effects on productive use. Once the dimensioning of the hardware is adequate, there are hardly any performance-related disadvantages. The main problem with a large database is that administrative handling becomes increasingly difficult. Consider the following points in relation to this: Backup and restore runtimes can increase by a significant amount, which – in serious cases – can lead to an unnecessarily long downtime. In addition to this, an online backup that is running can negatively affect the production operation, which is why online backups should also run for as short a time as possible. Note 842240 contains information about optimizing the backup and restore processes for large databases. The runtimes of operations on the database (such as consistency checks, database checks, reorganizations, index rebuilds or statistics creation) are relatively high and guarantee an
