cancel
Showing results for 
Search instead for 
Did you mean: 

Query tool performance issue

Frequent Contributor

Query tool performance issue

Hi Community,


I want to see all the Organizational process objects which are having history by using a query tool 

Select [Organizational Process]  Where [ChangedItemDataPublic] Is Not Null ".

When I run the above query, Hopex tool automatically going to not responding mode. even after 30 minutes also the same results.

When I run "Select [Organizational Process]"  is not taking more than 1 min for +- 7k objects.

Please help me out on this to improve the perfomance.

Note : Executed the default index rebuilding utility using administration tool.


Thanks

Raj 

Colruyt Team
2 Replies
MEGA Partner

Re: Query tool performance issue

Hi,

 

Which version of Hopex are you using ?

Frequent Contributor

Re: Query tool performance issue

Hello hsoegaard,

 

Currently we are using Hopex V2R1 Update 03 fixpack 02.

 

Thanks, 
Raj

Colruyt Team