Performance Tuning

[Anonymous]

Hi Team,

We are having multiple lookups for our data load. The performance has been greatly reduced. Do we have any performance tuning stpes?

Can anyone suggest us?

Thanks in advance,

Ramya.

[manodwhb]

@rchinta ,check below links may help.

http://talendexpert.com/talend-redshift-performances/

https://community.talend.com/t5/Design-and-Development/Performance-issue-with-Redshift-component/td-...

[Anonymous]

Hi Ramya,

    Updates are always costly operation in Redshift since its more tuned for data inserts as it is a data warehouse.

    Please refer below post update which will give you some better performance.

https://community.talend.com/t5/Design-and-Development/how-to-update-bulk-records-in-redshift/td-p/2...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thanks for the suggestions. But I am still unable to find a solution.

Quick question: I am using Open Studio but does that have any difference with the Enterprise Edition?

Thanks,

Ramya.

[Anonymous]

Hi Ramya,

     There should not ba any major changes for this component but support team will work with you to do the resolution within SLAs for Enterprise edition.

     Sometimes a Support patch, which is having on demand change for the customer might do the magic.

     I would also suggest to raise the issue with Talend Product Team through JIRA.

https://jira.talendforge.org

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂