Slow Form Loading from Database Query
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.
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.
Please sign in to leave a comment.