ADO Performance question
- From: "Pushkar" <pushkartiwari@xxxxxxxxx>
- Date: Thu, 27 Oct 2005 00:11:38 +0530
|
Hi,
I am writing a code which is actually performing
multiple inserts on a table.
Currently I am combining all my insert queries and
passing as command text to ADO command object.
There is one more way by opening a recordset and
call AddNew on recordset multiple times and then batch update.
But I am not sure which method is better than other
and which approach should I use.
Thanks in advance.
Pushkar |
- Follow-Ups:
- Re: ADO Performance question
- From: Stephen Howe
- Re: ADO Performance question
- Prev by Date: Custom marshalling of ADO.NET dataset to ADO Recordset
- Next by Date: Passing a RecordSet to a VB6 component byRef
- Previous by thread: Custom marshalling of ADO.NET dataset to ADO Recordset
- Next by thread: Re: ADO Performance question
- Index(es):