Improving Forms File Retrieval Performance

asked on November 1, 2018 • Show version history

In Forms, when requesting to download a previously uploaded file, there is a roughly 25 second wait time between when the user clicks to download the file and the download starts.

I assume this is how long it takes to prepare the document from BLOB data and I am trying to determine where to add higher performance processors to speed up the process.

However, the job is not processed on the web server OR the SQL server. Let me explain.

During the 25 second period, I checked the web server; nothing is accessing the CPU over 1%.

I profiled the SQL server; no RPCs or Batch transactions that take over 4 milliseconds.

Querying all BLOB data returns in less than 1 second, so there is no wait on getting the data from storage.

Where in the world is this file being generated if not in SQL or on the Web Server?

0 0

replied on November 2, 2018

The code here for downloading an uploaded attachment is pretty simple. It just queries the file from the table and does a binary write to the response. It all happens on the IIS machine.

Maybe a support case would help us investigate the lag. There shouldn't be a 25 second delay.

0 0

replied on November 6, 2018 • Show version history

We reduced the number of files being stored in the database down to 5GB and shoved it all into RAM by making sure there was enough available RAM and then running a select *. This Did not improve the performance at all.

It was apparent that the BLOB data was very fast to query though, even on disk, and there is no transactions that take over 4 ms during the wait time. I just wanted to make sure.

During the wait period, the IIS server is not processing anything, so we must be waiting on something else. I wouldn't even know where to start trying to create a support case, they require something packaged and ready to reproduce on their end. It is environment specific, I need someone who will remote in and help find the bottleneck.

Edit: I have also verified this is not due to any network appliance, by testing directly from a web browser on the IIS machine and eliminating any network traffic.

0 0

replied on November 6, 2018

For the support case, start with the problem and all the troubleshooting you've done thus far. Support can help figure out what's causing the lag and even remote into your machine if necessary.

0 0

Question

Question

Improving Forms File Retrieval Performance

Replies

Sign in to reply to this post.