运行动作查询异常延迟 [英] Abnormal delay in running action query

问题描述

我的一个分割数据库有一个追加查询，该查询设置为在卸载表单的事件上运行。但每当我关闭表单时，运行该查询都会出现异常延迟。

私有Sub Form_Unload（取消为整数）

On Error Resume Next

DoCmd.OpenQuery（" AppendToIssueSbase2"）

End Sub

Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
DoCmd.OpenQuery ("AppendToIssueSbase2")
End Sub

追加查询的sql是

INSERT INTO IssueSbase2（SibNo，SibNoM， Dateissue，CntrMode，VehID，jno，TransactionID，StockId，BulkId，Category，Nomenclature，QtyIssued，Scale，Cost，PoNo，PoDt，CompanyID）

SELECT TRANSACTION.CntrID，COUNTER.SibNo， COUNTER.CntrDt，COUNTER.CntrMode，COUNTER.VehID，COUNTER.jno，TRANSACTION.Tid，TRANSACTION.StockId，Stock.BulkId，Stock.Category，Stock.Nomenclature，TRANSACTION.Qty，Stock.Scale，[Qty] * [Rate ] AS Cost，COUNTER.PoNo，
COUNTER.PoDt，COUNTER.CompanyID

FROM（[TRANSACTION] INNER JOIN [COUNTER] ON TRANSACTION.CntrID = COUNTER.CntrID）INNER加入交易股票N.StockId = Stock.StockId

WHERE（（（TRANSACTION.Tid）不在（SELECT [TransactionID] FROM [IssueSbase2]））AND（（COUNTER.CntrFlag）=" Supply" ;））;

INSERT INTO IssueSbase2 ( SibNo, SibNoM, Dateissue, CntrMode, VehID, jno, TransactionID, StockId, BulkId, Category, Nomenclature, QtyIssued, Scale, Cost, PoNo, PoDt, CompanyID )
SELECT TRANSACTION.CntrID, COUNTER.SibNo, COUNTER.CntrDt, COUNTER.CntrMode, COUNTER.VehID, COUNTER.jno, TRANSACTION.Tid, TRANSACTION.StockId, Stock.BulkId, Stock.Category, Stock.Nomenclature, TRANSACTION.Qty, Stock.Scale, [Qty]*[Rate] AS Cost, COUNTER.PoNo, COUNTER.PoDt, COUNTER.CompanyID
FROM ([TRANSACTION] INNER JOIN [COUNTER] ON TRANSACTION.CntrID = COUNTER.CntrID) INNER JOIN Stock ON TRANSACTION.StockId = Stock.StockId
WHERE (((TRANSACTION.Tid) Not In (SELECT [TransactionID] FROM [IssueSbase2])) AND ((COUNTER.CntrFlag)="Supply"));

有没有办法加快此查询的运行速度？

Is there any way to expedite the running speed of this query?

我被重定向将此查询发布到MS社区的MSDN论坛

I was redirected to post this query to MSDN Forum by MS Community

谢谢。

推荐答案

如果您手动运行查询，是快速还是相同延迟？

If you run the query manually, is it fast or same delay?

平均附加多少条记录？

您最近是否已压缩？你的数据库？

Have you recently compacted your db?

你的网络是什么样的？ 快，慢？

What's your network like?  Fast, slow ?

这篇关于运行动作查询异常延迟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！