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 - Release Notes

      v480.1001 (Beta) RSA Algorithm has been implemented Company GUID and User GUID added to the user information UI Support for Azure Database Connection v480.1000 2025.03.10 (Beta) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to ...

    • 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

      v1000.1005 2023.11.16 Fix/add rename logic to all scripts The installer script is now Visual Version aware and will install the specific version support v1000.1004 2022.12.12 Reverse list order in data grid (added InvoiceDate for further ordering) ...

    • Smartviews Data Connection

      How to Add a data connection? Step 1 : Login to SmartViews and select Designer tab and Click on "Add" a data connection Currently, Smartviews support the following data connection: Microsoft SQL server MS Access MS Excel Oracle ODBC Lillyworks ...