Facing issue with query entity

Question

Hi All, 
 I am trying to quey the view which has 20000 rows. when i apply filter to one of the calculated column which has 0 rows present, queryentity still throws below error. 
 Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [ELMRISKREDUCTIONLANDINGPAGEVWDT16641], query: [queryentity expression], order by: [[Sort[eucInventoryId asc]]], filters:[(currentReductionStage in TypedValue[it=103,v={Process Re-engineering/Non GFT/ITeSS,}])]) 
 We tried optimizing the view as well, but no luck. 
 Any suggestion would be appreciated.

Harsha Sharma · Answer

How is the Explain statement looking for your view? 
 sayalic0004 said: when i apply filter to one of the calculated column which has 0 rows present, queryentity still throws below error. 
 Since its a view, the filter will work after fetching the entire dataset. When you try to fetch 1 row without any filters is it working? If yes, How much time it took to return the row. Is the view opening and performing well in database end? Basis the above answers, first and important step is to optimise the view only. If that also doesnt work then better to move to records instead of query entity and utilise Appian's Data Fabric to boost performance. This will need extra effort and care to replace joins with record relationships/ manipulations with custom record fields etc though!

Mike Schmitt · Answer

How long does the view itself take to load a standard display-screen of paged data when doing a similar filter? if it's anything more than, maybe, half a second or so, then the Appian query has no hope of being performant.

Shubham Aware · Answer

The view evaluates calculated columns on all 20,000 rows before applying filters, causing timeout even for 0-row results. Views often cause performance issues. Since you already mentioned that you tried optimizing your code, I recommend using Record Types with Data Sync.​​​​​​​​​​​​​​​

Facing issue with query entity

Top Replies