Slow Form Loading from Database Query

Guy Weisenbach

January 26, 2022 16:43

I have one form in the application that executes a stored procedure on the database and then returns the resultset to the form. Historically it takes about 45-60 seconds for data to appear in the form. I'm now seeing it take 4:30 to 5:00 minutes for data to show in the form (If I run directly on the server it's taking 2:15 to 2:30 minutes). 

If I execute the stored procedure from my database tool, it returns all data (about 250 rows) in about 3 seconds.

If I drop the Document Action Get URL into a browser I get the full XML in about 3 seconds.

Something is slowing down rendering the XML into the form and I can't see anything in the logs that would indicate why this is occurring.

Thoughts?

0

• Official comment

  

  Prajakta

  January 26, 2022 21:30

  Hello Guy,

  How many rows of data is the stored procedure returning? The more the number of records and data, the more time it will take frevvo to dynamically load those fields and then populate data in them. 

  Thanks,

  Prajakta

Please sign in to leave a comment.