How to insert batch record?

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by enoch Sun, 08 Apr 2001 11:18

#5533

Author: enoch
Date: Sun, 08 Apr 2001 11:18

12 lines
1342 bytes

Hello there,

What is the most efficient way to insert a lot of records to the database
using ADO?
I have tried to use TADOTable, Insert() and Post().  I dont know why when I
try to insert a varchar type (string type),  an exception will be threw.
So, I use TADOCommand and use SQL (INSERT) statement to insert the records.
But it take a lot of time to insert a lot of records (since it write each
record one by one).  I want to ask if there are other good method for it?
That is, insert records in batch.

Thanks.

Re: How to insert batch record?

#5548

Author: Mark Cashman
Date: Mon, 09 Apr 2001 23:44

15 lines
1483 bytes

Hi, Enoch!

I strongly recommend using moModifiedOnly for your MarshalOptions; that
drastically improves performance because it ensures that you only flush
changed (or inserted) records to the server. The default reflushes the
entire local data set on each change.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Re: How to insert batch record?

#5489

Author: Yuancai (Charlie) Ye
Date: Mon, 23 Apr 2001 01:35

25 lines
1720 bytes

Hi,
    See the site
http://www.geocities.com/oledbpro/docs/examples/multiprocs.htm.

Yuancai (Charlie) Ye
See 28 OLEDB examples at http://www.geocities.com/oledbpro
Use OleDBPro instead of ADOs and ADOExpress

"enoch" <enoch@memdb.com> wrote in message news:3ad0481d_2@dnews...
> Hello there,
>
> What is the most efficient way to insert a lot of records to the database
> using ADO?
> I have tried to use TADOTable, Insert() and Post().  I dont know why when
I
> try to insert a varchar type (string type),  an exception will be threw.
> So, I use TADOCommand and use SQL (INSERT) statement to insert the
records.
> But it take a lot of time to insert a lot of records (since it write each
> record one by one).  I want to ask if there are other good method for it?
> That is, insert records in batch.
>
> Thanks.
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads