Issue: Extremely slow query performance using ADO.NET connection to a SQL Server 2016 database using Appeon PB v2019 b2082.
Querying ~700 rows from SQL Server 2016 DB into a grid datawindow which is taking approx 2-3 minutes to complete (from compiled runtime or PB UI). Exact SQL executing using SQL Server Management Studio takes less than a second to pull the rows.
Any recommended performance DBParms for ADO.NET that may help? Also tried using the native SNC driver which is slightly faster (1-2 minutes), but this driver imposes a significant runtime distribution issue since the 200+ app users do not have sql client installed on the their workstations....
shouldn't take this long to query 700 rows from SQL Server? No performance issues pulling data from Oracle v11/12 databases using native driver.
sample connection profile