There are 2 configurations that can be made to the application server configuration to ensure optimal performance:
- Setting/Increasing the SQL command timeout
- Switching off authenticode verification to improve log on times
- Set Chunk Size When Uploading and Downloading Attachments
Set/Increase the SQL Command Timeout
All of the Q-Pulse data is held in a SQL database. When the information displayed in Q-Pulse is changed, the application will automatically perform SQL operations to update the data on the SQL server. While this is being performed, the default SQL timeout options will determine how long these operations will run for.
Increasing the timeout is recommended if:
- There is a large geographical distance between the application server and database server which may result in a delay carrying out tasks
- The SQL server hosts various other databases which may result in slower performance
- The user will be carrying out actions that require complex calculations to be performed (e.g. restructuring large managed lists)
To set the SQL command timeout: For Version 6 and below
- On the application server, browse to the Q-Pulse web site folder. By default, this will be C:\inetpub\wwwroot\QPulse5
- Locate and open web.config with Notepad
- Add a new entry to the <appSettings> section:
The value of the SqlCommandTimeout is in seconds and can be changed as needed.
- Save the web.config.
Benefits of Configuration | Details |
Control Over SQL Timeout | The time allowed for SQL commands to be performed can be controlled by IT. |
Additional Time to Perform Tasks | The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path). |
To set the SQL command timeout: For Versions 6-6.2
- On the application server, browse to the Q-Pulse web site folder. By default, this will be C:\inetpub\wwwroot\QPulse
- Locate and open web.config with Notepad
- Add a new entry to the <appSettings> section:
The value of the SqlCommandTimeout is in seconds and can be changed as needed.
- Save the web.config.
Benefits of Configuration | Details |
Control Over SQL Timeout | The time allowed for SQL commands to be performed can be controlled by IT. |
Additional Time to Perform Tasks | The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path). |
To set the SQL command timeout: For Version 6.5 and above
- On the application server, browse to the Q-Pulse web site folder. By default, this will be C:\inetpub\wwwroot\QPulseDataPortal
- Locate and open web.config with Notepad
- Add a new entry to the <appSettings> section:
The value of the SqlCommandTimeout is in seconds and can be changed as needed.
- Save the web.config.
Benefits of Configuration | Details |
Control Over SQL Timeout | The time allowed for SQL commands to be performed can be controlled by IT. |
Additional Time to Perform Tasks | The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path). |
Switch Off Authenticode Verification
In older versions of Q-Pulse (versions 5.51 to 5.90), the start-up process required authenticode verification. In order to do this, the application server will connect to the internet so that various file assemblies can be verified. This verification process can have a negative impact on the product in environments where network performance may be an issue and may prolong the log on process.
Important Note: This is a global setting and this change will affect all ASP.NET applications running on this server. If you have other ASP.NET applications hosted on this server please ensure that this setting is appropriate and that it will not impact the other applications. You can read more about the generatePublisherEvidence element on the MSDN webpage.
- Browse to %systemroot%\Microsoft.NET\Framework\v2.0.50727 and open the aspnet.config file in notepad.
- Add the line below within the <runtime> element:
- The contents of the file should look similar to the following:
Benefits of Configuration | Details |
Faster Product Login | The speed of the username and password box being displayed is increased. |
Set Chunk Size When Uploading and Downloading Attachments
Important Note: This section can only be implemented in Q-Pulse version 6.2 or later.
Some customers may experience issues when downloading and uploading attachments from Q-Pulse. Especially over the internet or slow networks. Currently in Q-Pulse the default chunk size is 128KB, however this can be increased by adding the tags found below to the web.config file for the Q-Pulse Dataportal.
Increasing the Chunk Size: For Version 6 and below
1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulse5.
2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB.
<add key="DownloadChunkSize" value="2097152"/>
<add key="UploadChunkSize" value="2097152"/>
Benefits of Configuration | Details |
Faster Download and Upload of Documents | The speed in which Documents are download/uploaded to and from the client will be increased. |
Increasing the Chunk Size: For Version 6-6.2
1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulse.
2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB.
<add key="DownloadChunkSize" value="2097152"/>
Benefits of Configuration | Details |
Faster Download and Upload of Documents | The speed in which Documents are download/uploaded to and from the client will be increased. |
1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulseDataportal
2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB.
<add key="DownloadChunkSize" value="2097152"/>
<add key="UploadChunkSize" value="2097152"/>
Benefits of Configuration | Details |
Faster Download and Upload of Documents | The speed in which Documents are download/uploaded to and from the client will be increased. |
Comments
0 comments
Please sign in to leave a comment.