TADOConnection

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

Article #2724

Back to borland.public.cppbuilder.database.ado Previous Next

#2724

From: In�s Fern�ndez
Date: Mon, 14 Apr 2003 07:51

17 lines
1602 bytes

Hello!
I am using a TADOCommand component to insert records in a Table from an SQL
Server Database.
Each time I have to call that command about 17000 times to insert as many
records.
The process takes quite a long time, so I am looking for a way to make that
time shorter.
I have found that using a TADOConnection to connect to de Database it takes
twice the time it takes using the ConnectionString directly in the
TADOCommand component. Why?
Is there a way to solve this? I want to use the TADOConnection component
because I have many other ADO components that must connect to the same
Database.

Thanks in advance:

In�s Fern�ndez

Technical Details

Message-ID: <3e9a6882@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,4246570f02c5cb36,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-14 00:56:07 PST
From: "In�s Fern�ndez" <ifernandezmed@terra.es>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOConnection
Date: Mon, 14 Apr 2003 09:51:40 +0200
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 80.59.94.142
Message-ID: <3e9a6882@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1050306690 80.59.94.142 (14 Apr 2003 00:51:30 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail