Partitioning of database

Question

Marketing server and DB (Oracle) - In house in client premises.

Data is getting loaded for multiple Business units.

For better performance of database, client is looking for partitioning of database.

What are the best practices that can be suggested to clients for partitioning.

Would there be any change at Adobe Campaign application level (any changes to existing workflows or queries) if the database is partitioned?

Please help with pointers.

ShrawanSaxena-1 · Accepted Answer

Hi Priyanka,You go through below links to know more on best practices.Adobe Campaign Classic data model best practices Best practices for performance improvement on Campaign Classic DB partitions is something at DB level and I do not think you need to change anything at campaign level.

AakashGu · Answer

Hi Priyanka,You can refer to the following resources for more information on database partitioning and performance best practices:Adobe Campaign Classic Data Model Best PracticesDatabase Partitioning Best Practices for OracleDatabase partitioning is generally managed at the DB level, and typically, no changes are required at the Adobe Campaign application level unless specific workflows or queries are dependent on the exact data structure. It’s always a good idea to test the changes in a staging environment before implementation."

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded