Re: Inserting new records into a large ADO table
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Mon, 23 May 2005 12:34:10 +0400
Use prepared command - in this case only parameter values will be sent over
network.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Edward Diener" <eddielee_no_spam_here@xxxxxxxxxxxxxx> ???????/???????? ?
???????? ?????????: news:429110f4$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Bill Todd wrote:
>> Huh? When you call CDS.ApplyUpdates the DataSetProvider creates and
>> executes one SQL statement for each change in the CDS.Delta property.
>> If you insert 1,000 rows the DSP will create and send to the server
>> 1,000 INSERT statements.
>>
>> There is no magic way to send a SQL database server one statement that
>> inserts 1,000 rows.
>>
>
> OK, thanks for the info.
.
- Follow-Ups:
- Re: Inserting new records into a large ADO table
- From: Edward Diener
- Re: Inserting new records into a large ADO table
- References:
- Inserting new records into a large ADO table
- From: Edward Diener
- Re: Inserting new records into a large ADO table
- From: Bill Todd
- Re: Inserting new records into a large ADO table
- From: Edward Diener
- Re: Inserting new records into a large ADO table
- From: Bill Todd
- Re: Inserting new records into a large ADO table
- From: Edward Diener
- Inserting new records into a large ADO table
- Prev by Date: Re: Optional feature not implemented
- Next by Date: Re: Inserting new records into a large ADO table
- Previous by thread: Re: Inserting new records into a large ADO table
- Next by thread: Re: Inserting new records into a large ADO table
- Index(es):
Relevant Pages
|
