|
|
От: |
Elena_
|
|
| Дата: | 29.10.04 22:14 | ||
| Оценка: | |||
When you create an ADO recordset retrieving Jet data, do not specify adUseClient for the recordset's CursorLocation property. (The default is adUseServer, so you would have to specify adUseClient intentionally.) Although it may seem that because Jet isn't a client/server database engine, you should choose adUseClient, this logic is incorrect. If you choose adUseClient for the CursorLocation property, you're asking ADO to create its own cursor, in addition to the one Jet always creates. The time difference between using adUseClient and adUseServer is measurable, so don't fall into this trap unless you have some reason to use adUseClient. (Disconnected and in-memory operations, for example, require a client-side cursor, so you won't be able to avoid using adUseClient.)