Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
galitzel
Contributor
Contributor

Attunity Tasks Best Practices

Hi, 

How many tables are recommended to include per task in Attunity? Considering that we always use unidirectional replications. 

Thanks

Labels (1)
1 Reply
john_wang
Support
Support

Hello @galitzel ,

From theory there is no limitation, however there must be some limitation to gain the best performance, include the network, CPU, memory, harddisk performance of the source DB, Replicate server, target DB etc. It depends on hardware , source DB /target DB database types and so on, it's hard to tell in a simple formula.

In general there are few thousands tables are included in a single task. As far as I know, one of our customer has more than 10K+ tables in a single task and all works fine, include Full Load and CDC. 

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!