Re: advice with huge database

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

Article #2343

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

#2343

From: Yuancai (Charlie) Ye
Date: Tue, 26 Aug 2003 17:06

30 lines
2003 bytes

Hi,
    try OleDBPro at www.udaparts.com with provided real and advanced
samples. OleDBPro is the best OLEDB consumer library for C++ development
only.  It is especially great for large databases.

-- 
Yuancai (Charlie) Ye
RDB, a tool for fast and securely accessing remote databases with dial-up,
cable, DSL and wireless modems anywhere

Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, non-blocking and parallel computation

See 30 well-tested and real OLEDB examples
www.udaparts.com


"Dr. Kevin Chugh" <chugh@buffalo.edu> wrote in message
news:3F453052.32D60D31@buffalo.edu...
>
> hi - i'm building a huge database, which may have several hundred
> million records in one table.  i'm currenly using a local access 2000
> file, a TADOConnection, and a couple of TADOQueries.  the problem is
> that appending new records is incredibly slow- i want to impend a few
> hundred thousand records at a time.  what is the best way to accomplish
> this quickly?
>
> thanks,
> kevin
>

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3F453052.32D60D31@buffalo.edu>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ad4f788dd25a23b7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-08-26 10:12:05 PST
From: "Yuancai \(Charlie\) Ye" <yekerui@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3F453052.32D60D31@buffalo.edu>
Subject: Re: advice with huge database
Date: Tue, 26 Aug 2003 13:06:42 -0400
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 143.101.239.86
Message-ID: <3f4b9387@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1061917575 143.101.239.86 (26 Aug 2003 10:06:15 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message