Export (0) Print
Expand All

Using Rowsets Efficiently

SQL Server 2000

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.

See Also


© 2015 Microsoft