当您使用网络上的访问数据库时会发生什么? [英] What happens when you use an access database located on your network?

问题描述

1.例如，如果您通过ADO.Net SQL向一个表中的一个或多个记录发出请求–整个表是否传递回客户端以进行解析?更糟糕–是否将整个文件传回进行处理?或者–喷气引擎能够提取单个表，或者在多表查询的情况下-受影响的表?

2.在插入或删除记录时会发生什么?再说一遍–是将整个文件或表传递回调用方进行解析和处理–还是喷气引擎能够在不传递返回的情况下进行处理?

3.在对表进行大规模SQL更新时会发生什么.说-UPDATE flag=True WHERE flag=False.

我感谢所有帮助.如果答案对大多数人来说很明显，我深表歉意.

谢谢Jim H

1. For example if you make a request via ADO.Net SQL to one or more records from a table – Is the whole table passed back to the client for parsing? Worse – is the whole file passed back for processing? Or – is the jet engine able to extract the single table or in the case of a multi-table query - the affected tables?

2. What happens on the insert or delete of a record? Again – is the whole file or table passed back to the caller for parsing and processing – or is the jet engine able to handle this without passing back?

3. What happens on a mass SQL update to a table. Say - UPDATE flag=True WHERE flag=False.

I appreciate any and all help. I apologize if the answer is obvious to most.

Thank you Jim H

推荐答案

不，整个文件不会来回传递.通信实际上发生在您的代码和ODBC驱动程序之间，并且驱动程序完成了它需要做的所有工作.

No, the entire file is not passed back and forth. The communication actually takes place between your code and the ODBC driver and it is the driver that does whatever work it needs to.

这篇关于当您使用网络上的访问数据库时会发生什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！