cancel
Showing results for 
Search instead for 
Did you mean: 

DQL Performance/Optimization

Phil_Rosier
Level 4

Is there anyway of optimizing DQL such that engine will take notice of the device.name fields in the WHERE clause; such that it only runs the query on the indexer(s) associated with the specified devices?

The problem that I having is that the DQL queries seem to take an extraordinarily long time to run on the Indexers that are not associated with the device, resulting in reports that should take minutes taking several hours to run.

Regards

Phil

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Rishi_Thaper
Level 4
Employee

Hi Phil,

There was an issue with DQL processing for device.name field in one of the cases which will be fixed in next release.

Thanks,

Rishi

View solution in original post

2 REPLIES 2

Rishi_Thaper
Level 4
Employee

Hi Phil,

Can you send me the DQL query being utilized here? Ideally, the query execution should be performed on relevant indexers only.

Thanks,

Rishi

Rishi_Thaper
Level 4
Employee

Hi Phil,

There was an issue with DQL processing for device.name field in one of the cases which will be fixed in next release.

Thanks,

Rishi

View solution in original post