Skip to main content
S
sharathp0002
June 7, 2023
Question

Issue while executing Queryentity.

  • June 7, 2023
  • 2 replies
  • 0 views

Hi All,

We are using a queryentity to retrieve the data from DB View. While retrieving the data we are seeing below intermittent issue. Our query rule is too long, I have attached that. Any suggestions to optimize this rule.  

at function a!queryenti[View:/cfs-file/__key/communityserver-discussions-components-files/16/Query_5F00_Code.txt:320:240]ty an error occured while retreiving the data. Details: unexpected error executing query 

Thanks

2 replies

mathieud0001
mathieud0001
Brainy
June 7, 2023

You could try reducing the number of columns you are returning.

It seems like you are querying a view. I would suggest that you look at the underlying query and see if you can't optimize that. You could also add some indexes on some of the underlying tables. Finally you could build materialized views (physical tables that you refresh from time to time).

stefanhelzle0001
stefanhelzle0001
Brainy
June 8, 2023

Database views are known for degrading performance with an increasing data volume if not designed and optimized carefully. Do you have a chance to switch to synced records?

Terms & ConditionsAccessibility statement