开发者

Delete slow SQL Server table linked to Microsoft Access

开发者 https://www.devze.com 2023-02-14 18:03 出处:网络
I have a link from Microsoft Access to a SQL Server table.The 开发者_开发技巧I/O is pretty good except when I tell it to delete some 1400 records.It takes about 45 seconds to process through that.

I have a link from Microsoft Access to a SQL Server table. The 开发者_开发技巧I/O is pretty good except when I tell it to delete some 1400 records. It takes about 45 seconds to process through that. If I issue the same delete command in SSMS, it runs instantaneously.


Run it as a pass-through query

0

精彩评论

暂无评论...
验证码 换一张
取 消