Access中的SQL语句导致Windows 10上的速度问题

Question

我有一个vb6程序，它调用一个vb.net程序来打印DevExpress报告。这些程序多年来一直运行良好，直到去年在一些pc上升级到Windows 10 (这些是全新的pc)。通常，报表打印大约需要2秒，但在一些新pc上(并非全部)，当试图用dataAdapter填充datatable/datareader时，程序会挂起。其他人认为这是sql声明中的一些东西，尽管我们在所有Windows 7个人电脑和大约5台Windows 10 pc上都没有问题，但这只发生在某些Windows 10 pc上。

这个sql语句能被彻底清除吗？最后，SwatKey是惟一的变量：

              "SELECT WeightCert, [SwatLog].[SwatDate], TareDate, SaleCode, " &
                "Species, Qual, SaleDesc, Trucker, TruckNo, TruckState, " &
                "TruckLic, TrlState, TrlLic, TruckType, Comments, TareLoad, " &
                "ScaleLoad, LoadNo, Logger, LogMethod, Block, Val(Gross) as GrossWt, " &
                "Val(Tare) as TareWt, Weight, PrintAvg, Brand, Commodity, SortCode, " &
                "Deck, UserInfo1, UserInfo2, EmergencyLevel, ReprintCount, " &
                "Reason, LocationName, Addr1, Addr2, OwnerName, LoggerName," &
                "Contract, Weighmaster, TT, Reprint, TareoutBarcode, PrintTare, TruckName, " &
                "ManualWeight, DeputyName, CertStatus, ReplacedCert  " &
          "FROM Swatlog INNER JOIN tblTempCert " &
            "ON [SwatLog].[SwatDate] = [tblTempCert].[SwatDate] " &
         "WHERE [tblTempCert].[SwatDate] = #" & SwatKey & "#"

Answer 1

首先，确保您在字段SwatDate上有指示。

接下来，尝试对另一个表进行过滤：

"WHERE [swatLog].[SwatDate] = #" & SwatKey & "#"

或两者兼备：

"WHERE [tblTempCert].[SwatDate] = #" & SwatKey & "# And [swatLog].[SwatDate] = #" & SwatKey & "#"