At first, we also guessed that the 1500 rows query is the one which cause the slowing down. However, this is what we observe:
- Whenever the client machine is restarted, the time it takes to load and display LiveCycle ES Sample MortgageLoan-Prebuilt PDF form in Workspace will be slow (more than 10s). Subsequent try of loading the PDF form will be faster (2-3s)
- Whenever the client machine is restarted, the time it takes to load and display our prepopulated PDF form in Workspace will be slow (15-25s). Subsequent try of loading the PDF form will be faster (5-7s)
- In our custom Default Render process, we write trace message to server.log file at the start and end of the process. We noticed, the time it takes between the start and the end of the process is consistently about 2-5s which include retrieval of 1500 db records.
Please advice.