Delay of response Filtering Query

[Former Member]

Hi All,

I have a situation whereby I have a query in Multiprovider, when I run the query and do a filtering by Product Order, Order No, Doc No ... it takes almost 20 minutes for me to see the selection. In this query there is a lot of CKF and RKF ... I know this will hamper the performance.

Can anyone advise on turn around method .... including creating indexes.

Please advise

TQ

BR

Nathan

[Former Member · Accepted solution]

Try creating indexes for Product Order, Order No, Doc No, ... on the InfoProviders supplying these values to the MultiProvider.

I had a very similar issue recently, and doing this solved the problem.

Hope this helps...

Bob