Developer forum

Adrian Ursu

Posted on 31/12/2018 16:11:19

Hi guys,

I was wondering if there is any way I can get the DoNotFailOnMismatchingProductCount behavior on a SQL Index Builder in DW8.

A patch or a custom SQL Index Builder.

I have a very complicated query that takes like forever to run and I cannot get it to run unless I put the count in manually.

I know there is a timeout at 20 seconds for the count query.

If there is anyway I can increase that timeout or make it irrelevant for the index to run, it will help a lot.

Thank you,

Adrian

Nicolai Pedersen

Posted on 02/01/2019 10:07:01

Hi Adrian

I can provide you the source code for the DW8 version - should be simple to change and add it as your own custom SQL provider?

Another idea could be to make a stored procedure on the SQL server and query that for the count instead.

BR Nicolai

Adrian Ursu

Posted on 02/01/2019 11:46:10

Hi Nicolai,

Both options makes total sense.

I will see which one works best.

Thank you,

Adrian

You must be logged in to post in the forum