I need a snapshot record set. I am using MFC database access classes. Do I have to set option useCursorLib when call CDatabase::OpenEx()? Can I omit the option but specify "snapshot" type in CRecordset::Open()?
When I set option useCursorLib, opening a record set from the connection consumes tremendous amount of memory even though text or binary fields in each record are null (actually each record seems to take equal amount of memory on hard disk). There is no such problem when useCursorLib is not specified but record set type is snapshot.
I appreciate very much if you would share your knowledge on this.
When I set option useCursorLib, opening a record set from the connection consumes tremendous amount of memory even though text or binary fields in each record are null (actually each record seems to take equal amount of memory on hard disk). There is no such problem when useCursorLib is not specified but record set type is snapshot.
I appreciate very much if you would share your knowledge on this.