Using Rowsets Efficiently
When you plan an efficient data access strategy for Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE), keep the following issues in mind:
When you use deferred update mode in OLE DB, specified by DBPROP_IRowsetUpdate being set to VARIANT_TRUE, SQL Server CE can only have one pending change at a time. This uses a fast mechanism to update internally.
- IRowset::RestartPosition is efficient when used with scrollable cursors, but it can cause query reexecution when it is used with nonscrollable cursors. For more information, see Working with Cursors and Cursors.
- Although SQL Server CE supports OLE DB data type coercions to and from DBTYPE_WSTR, it is best to use native data type bindings where possible to maximize performance against this engine.
- SQL Server CE supports reading and writing to large image and ntext data types through the ISequentialStream and ILockBytes interfaces. For more information, see Working with Large Data Types.