Hot answers tagged

3

Avoid the multiple DLookUps with eachTreeView.Nodes.Add call for every row of recordset! At the very least store your DLookUp value once and apply it to treeview. This cuts down the repetitive 4 calculations down to 2 for every row. But since DLookUp essentially is a query anyway, simply integrate a JOIN to Master object in SQL queries of OpenRecordset calls....


2

Before anything, read on SQL parameterization and avoid concatenating or interpolating variables directly in SQL statements. Otherwise you open your application to SQL injection and inefficiencies. The module, psycopg2, has much support for parameterizations as their docs indicate. Secondly, save cur as another self. attribute and handle cursor and ...


1

Data location This is probably a weirdness from MSSQL itself and not specifically your setup, but your database location: FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLAssessment.mdf', as well as MSSQL's own default Database Engine data file location: \Program Files\Microsoft SQL Server\MSSQL{nn}.<InstanceID>...


Only top voted, non community-wiki answers of a minimum length are eligible