Re: ADO high virtual memory usage

Gareth Hopkins wrote:
rs.updatebatch(adAffectAll);
I doubt it has anything to do with your problem, but can you explain why
you are using updatebatch with an ad hoc recordset? Updatebatch is
intended to be used with a recordset with locktype set to
adLockBatchOptimistic which has been opened on a data source,
disconnected from that source, had updates done and reconnected to the
data source. I doubt this line can be doing anything in your test app
since there is no data source to which it can send the batched updates.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages