SmartViews - Extend Query Timeout

SmartViews - Extend Query Timeout

In some cases, you may want to extend the connection timeout in SmartViews if the query takes longer than the default 30 seconds to execute.  To do this:

Edit / Create a New View, select your database connection, then click "Edit"


When the Connection Wizard opens, click on "Advanced"


Scroll the advanced options until you see "Connect Timeout" and raise the limit.  (This field is in seconds):



Click OK here, and in the main Connection Wizard to save these changes.  Sync afterwards so this connection change can be synced on other SmartViews machines.

Warning
Please note that extending the connection timeout can cause performance issues on the database.  The query itself should always be investigated first and optimized before choosing to extend the connection timeout.
 

    • Related Articles

    • SmartViews - User Guide

      Prerequisites: Windows Server 2012R2-2022 Windows 8-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x- .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...

    • SmartViews - Release Notes

      v480.1000 (2025.01.09) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic ...

    • Sql Server LocalDB Installation for New SmartViews

      Installation Instructions As of version 462.1000, SmartViews uses LocalDB 2017 in place of the previous local cache. As such, LocalDB 2017 or later needs to be installed on the machine, and an important patch needs to be applied. LOCALDB 2019 ...

    • SmartViews Network Requirements

      In addition to connecting to other databases to view their data, SmartViews also needs to be able to connect to a designated SmartViews database in order to run. This SmartViews database stores the data in SmartViews, such as user accounts, Views, ...

    • Shipper Connect - Release Notes

      "DatabaseConnectionUI: Fix Server not always being disabled for Oracle DatabaseConnectionUI & DefaultDatabaseConnectionUI: Ignore case for string compares FrmMain: Eliminate try/catch for alias" Add MacroStub.vms to the ClientLoader Project Macro ...