Using Oracle Binds with ADO

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

Article #4685

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

#4685

From: Graham Reeds
Date: Wed, 31 Oct 2001 10:57

17 lines
1654 bytes

I currently have a utility to import data into an Oracle 8.1.6 table and I
was looking at ways of improving the speed of the importing of the data.
Inserting 100,000 records take almost 15 minutes to perform so I was looking
at speeding up the insertion by using Binds and variables.  However all the
examples in the books I have use PL/SQL and generate content on the fly,
whereas I am using the ADO components and need to import the data from
several hundred files.  Since this project is on a backburner at the minute
(we have some more pressing matters at hand) I was wondering if this was
possible, if there are any gotchas people have encountered when doing this
and any tips people can provide.

Thanks.

--

Yours faithfully, Graham Reeds.
grahamr@omnieng.co.uk | http://omnieng.co.uk/

Technical Details

Message-ID: <3bdfd9af_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d90e2575b197fed0,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-10-31 03:08:52 PST
From: "Graham Reeds" <grahamr@omnieng.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Using Oracle Binds with ADO
Date: Wed, 31 Oct 2001 10:57:50 -0000
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 212.172.148.2
Message-ID: <3bdfd9af_1@dnews>
X-Trace: dnews 1004525999 212.172.148.2 (31 Oct 2001 02:59:59 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews