Re: advice with huge database

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

Article #2328

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

#2328

From: Viatcheslav V. Vassiliev
Date: Fri, 22 Aug 2003 05:18

29 lines
2187 bytes

The fastest way - OLEDB Direct (http://www.oledbdirect.com). It works with
OLEDB and avoids ADO layer. On ADO - use server-side cursor and do not
forget to call TADOQuery.DisableControls() even if there is not controls
attached.

For database with several hundred million records you should choose another
database. MS Jet (MS Access) is not designed for so much data and it has
limit - 2 GB per database.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Dr. Kevin Chugh" <chugh@buffalo.edu> ???????/???????? ? ???????? ?????????:
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: <3f45a90f$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!167.206.3.103.MISMATCH!news3.optonline.net!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!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-21 22:31:18 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3F453052.32D60D31@buffalo.edu>
Subject: Re: advice with huge database
Date: Fri, 22 Aug 2003 09:18:49 +0400
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.247.201.57
Message-ID: <3f45a90f$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1061529871 213.247.201.57 (21 Aug 2003 22:24:31 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!167.206.3.103.MISMATCH!news3.optonline.net!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Reply to Parent Message