Redshift Performance Assurance

More
11 months 2 weeks ago #14440 by kavya
kavya created the topic: Redshift Performance Assurance
Hi,

We would like to purchase the software for the redshift connection. But with our initial POC from the trail version. The performance of the query was very low.

The direct query takes around 2 mins in redshift
Linkedserver : 45 minutes

Could you give us an actual software or a work around to make sure the performance is not so bad before proceeding ahead with purchase.

And also the discount plan for the same.

Note ; After purchase is it mandatory to uninstall the trial software and install the new one? or can we just update license and things would run smooth.

Warm Regards
Kavya Marigowda

Please Log in or Create an account to join the conversation.

More
11 months 2 days ago - 11 months 2 days ago #14446 by admin
admin replied the topic: Redshift Performance Assurance
Hi, please make sure to reduce the number of round-trips to the Redshift by adding the following parameters to the Provider String/Extended Properties:
MIN_FETCH_ROWS=5000;EVENTS=NONE;

Also, I recommend running PGNProfiler (as Administrator), and see what takes the most time. Most likely the linked server pulls a lot more data than is needed. There are various methods to address this, e.g. adding LIMIT/OFFSET clauses to the query.

Please send us a trace collected in the PGNProfiler for further analysis.
Last Edit: 11 months 2 days ago by admin.

Please Log in or Create an account to join the conversation.

Time to create page: 0.120 seconds
Powered by Kunena Forum