advice with huge database

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

Article #2327

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

#2327

From: Dr. Kevin Chugh
Date: Thu, 21 Aug 2003 20:49

10 lines
1337 bytes

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: <3F453052.32D60D31@buffalo.edu>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ad4f788dd25a23b7,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-08-21 13:46:06 PST
Message-ID: <3F453052.32D60D31@buffalo.edu>
Date: Thu, 21 Aug 2003 16:49:22 -0400
From: "Dr. Kevin Chugh" <chugh@buffalo.edu>
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: advice with huge database
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 128.205.213.14
X-Trace: newsgroups.borland.com 1061498588 128.205.213.14 (21 Aug 2003 13:43:08 -0700)
Lines: 11
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail