You are viewing limited content. For full access, please sign in.

Question

Question

Excessive Instance History on Form

asked on October 15, 2018

I have a form that I've been working on (in a testing stage).  It has several tables that are updated from a database.  I'm loading the data into the tables from Workflow, and this is working very well.

The process in Forms causes the form to check Workflow for new records in the database and then reassign the form back to the user - multiple times during the month.  At the end of the month, the process is completed and finalized.

Potentially, this process could result in the Workflow that checks the database and re-populates the tables in the forms to run dozens and dozens of times during the month.

Will all this extra history in the instance cause the forms to load slowly or have any other issues?  I don't mind if the administrator side of things is slow (when I look up details on the Monitor page for example) - I just want to make sure that the end users don't have to wait a very long time each time they load the form, just because it's trying to process something with all this extra history.

0 0

Replies

replied on October 16, 2018 Show version history

This sort of problem is where a fully qualified DBA is needed. They can do stress testing and performance monitoring of your database when you run your tests, and give you an analysis of what the load will be like in full production. They can also provide suggestions for how to fix any problems that do crop up during testing.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.