View Revisions: Issue #6643
| Summary | 0006643: Speed up SymmetricDS upgrade process by grouping drop/add column statements in DatabaseUpgradeListener (for internal tables) | ||
|---|---|---|---|
| Revision | 2024-11-11 18:26 by pbelov | ||
| Additional Information | Warning: Oracle is known to processes column changes very slowly! See for details: https://www.red-gate.com/simple-talk/databases/oracle-databases/dropping-columns/ Note: In contrast, PostgreSQL is very fast in dropping columns, because they are marked unused and not physically removed until the next VACUUM job runs. https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-NOTES |
||
| Revision | 2024-11-11 19:34 by pbelov | ||
| Additional Information | Warning: Oracle is known to processes column changes very slowly! See for details: https://www.red-gate.com/simple-talk/databases/oracle-databases/dropping-columns/ Note: In contrast, PostgreSQL is very fast in dropping columns, because they are marked unused and not physically removed until the next VACUUM job runs. https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-NOTES Note: SQLite is an example of database engine, which support only one column change at a time. |
||