PGNP OLEDB driver poor performance

More
3 weeks 5 days ago #14423 by Sanjeewan
Hello All,

I successfully connected with cube using redshift driver but its performance to process the data is very much poor its taking almost four time more time to process the cube .

SQL Server 20 mins ,
Redshift : 2 hrs approx .

any suggestion to improve this

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

More
3 weeks 4 days ago #14424 by admin
Hello Sanjeewan,
if you are using licensed product, then there a several parameters to tune performance. For example, in the Extended Properties of the connection string, add MIN_FETCH_ROWS=5000; in order to reduce number of round trips. There are ways to optimize metadata retrieval, etc. For more details refer to the Developer's Manual (available from the Download page on our web site).

If you are using Trial version, then effects of the tuning are not that apparent since the Trial returns maximum 100 rows for a query. The Trial is intended to demonstrate connectivity and ability to process small cubes. For speed and scalability you will need a licensed product.

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

More
3 weeks 4 days ago #14425 by Sanjeewan
Hello Admin,
Thank you for your quick reply .
I have licensed version of the product
I changed as per your suggestion .
Extended Properties of the connection string, add MIN_FETCH_ROWS=5000; in order to reduce number of round trips
Can you please explain bit more
There are ways to optimize metadata retrieval, etc Steps

Regards,
Sanjeevan

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

More
3 weeks 3 days ago #14426 by admin
Please refer to the Developer Manual (chapter 3.9 The Query Optimizer). Part 3.9.4 describes optimization of metadata retrieval.
Before proceeding with tuning and optimizations, I would highly recommend running PGNProfiler utility, and find what takes most time. Feel free to contact our Support if you will need help using the utility.

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

More
3 weeks 3 days ago #14427 by Sanjeewan
Hello Admin,
Thank you for your reply ,
I have 15 fact table in redshift and all fact tables contain million of rows .
so while choosing the connection string what should be the right option while connecting to SSAS cube
InelltellisoftOLEDB\Intellisoft Redshift OLEDB Provider
or
Intellisoft Redshift OLEDB Provider (BI ALIAS)

Regards,
Sanjeevan

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

Time to create page: 0.135 seconds
Powered by Kunena Forum