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.
Please sign in to leave a comment.